Annulé

Prestashop 1.4.4.1 - import shipping tracking numbers from CSV file

We would like to be able to import carrier tracking numbers into the mysql orders table into the shipping_number field

At the end of the day, we download [url removed, login to view] shipping report from City Link carrier.

[url removed, login to view] contains many columns exported from City Link, but we are interested in 'Reference' and 'Consignment No' columns only.

Pseudo code is something like this:

tracking_info = array (report.csv->reference => report.csv->Consignment_No)

foreach (tracking_info as $tracking){

if (pregmatch /d+/ $[url removed, login to view]){ //reference number pattern to match Prestashop invoice number

If (''==orders.shipping_number) {

orders.shipping_number = $[url removed, login to view];

//Perform all other actions (see note below)

logfile < 'Order #: ' . orders.id_order . ' Tracking #: ' . orders.shipping_number;

}

else {

logfile < 'Tracking # ' . orders.shipping_number . ' already exists for order # ' . orders.id_order . '. Cannot enter new value ' . $[url removed, login to view];

}

}

}

In addition to adding the tracking value to the orders.shipping_number field in the orders table, all other actions should be performed. For example, when we manually add a tracking number to an order, when we click the 'Set tracking number' button, one of the actions that takes place is that an email is sent to the customer informing them of the tracking number for their order. (There might be other actions too (updating other database tables???), not sure).

Compétences : e-Commerce, MySQL, PHP, Paniers d'Achat, Architecture Logicielle

Voir plus : prestashop add tracking number, set shipping number prestashop, prestashop tracking number, prestashop shipping tracking number, import csv shipping prestashop, value city, new prestashop, foreach php mysql, prestashop shipping csv, tracking number, shipping tracking, pseudo code, prestashop import, prestashop email, prestashop carrier, email tracking, d tracking, click tracking, prestashop invoice tracking number, csv php prestashop, tracking php code, php file array, customer invoice report, php table array, php table csv

Concernant l'employeur :
( 0 commentaires ) Gorey, Ireland

N° du projet : #2408514

7 freelances ont fait une offre moyenne de 21 $ /heure pour ce travail

toinnisfree

pls chk pmb

25 $ USD / heure
(540 Commentaires)
7.8
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

15 $ USD / heure
(224 Commentaires)
7.8
p4provider

We have all the required designer and developer you are looking for and can allocate dedicated resources for your project. You will be very happy and satisfied of our services.

20 $ USD / heure
(62 Commentaires)
7.2
getndone

Please check my message

25 $ USD / heure
(38 Commentaires)
5.2
mxicoders

Hi! We would like to discuss you about your web development requirement "Prestashop 1.4.4.1 - import shipping tracking numbers from CSV file". Please let me know your convenient time to discuss. We have more t Plus

25 $ USD / heure
(9 Commentaires)
4.9
itconsultindia

prestashop/php team

20 $ USD / heure
(9 Commentaires)
3.0
programer218

I can work prestashop project! Please check my portfolio! Thank you!

15 $ USD / heure
(5 Commentaires)
3.0
raaz0708

Hi ______________

20 $ USD / heure
(0 Commentaires)
0.0