Prestashop - 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

en voir plus : prestashop add tracking number, set shipping number prestashop, prestashop tracking number, prestashop add tracking number order, prestashop shipping tracking number, import csv shipping prestashop, value city, new prestashop, foreach in php and mysql, prestashop csv import tracking number, prestashop shipping csv, tracking number, shipping tracking, pseudo code, prestashop import, prestashop email, prestashop carrier, end in 1 day, email tracking, d tracking, click tracking, prestashop invoice tracking number, csv php prestashop, tracking php code, php file array

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

Nº du projet : #2408514

7 freelance font une offre moyenne de $21/heure pour ce travail


pls chk pmb

$25 USD / heure
(540 Commentaires)

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

$15 USD / heure
(224 Commentaires)

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)

Please check my message

$25 USD / heure
(38 Commentaires)

Hi! We would like to discuss you about your web development requirement "Prestashop - 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)

prestashop/php team

$20 USD / heure
(9 Commentaires)

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

$15 USD / heure
(5 Commentaires)

Hi ______________

$20 USD / heure
(0 Commentaires)