CSV (can be changed also to another format) import of products (combinations) into prestashop 1.5

In Progress Posted Jan 2, 2014 Paid on delivery
In Progress Paid on delivery

CSV (can be changed also to another format) import of products (combinations) into prestashop 1.5

Should be splitted into two parts (because it is not necessary to update all the products all the time):

1. Full Update of the stock and price(will be used sometimes)

2. Changed Items Update of the stock and price (will be used minimum once per day, may be also triggered more often)

Concrete Example:

A CSV File will be generated with the changes of the last hour, for example:

(Reference Code, Size, Combination Quantity, Price, taxRate (if necessary – will be the same all the time), feature1)

Product1_referenceCode, 48, 5, 129, taxrate, 2014_v

Product2_referenceCode, 50, 3, 99, taxrate, 2014_v_p

Product3_referenceCode, 48, 5, 129, taxrate, 2013_v

Ad 2. With that information the webshop should be updated (key is the product reference code). There is just a small filter in between: Products with a reference code starting with one or two specific letters should be ignored. If there is no corresponding product, there should be a log file with the missing reference code (which could be also sent to a specific email adress)

Ad 1. The Full Stock update should be done in the opposite direction to find out if there is a product in the webshop with no corresponding reference number (because of whatever reason). Therefore the products from the webshop should be taken and checked if there is a corresponding reference number, if yes, of course the update should be the same as in the partial update routine, but if not there should be also a log file which should be also emailed with the reference numbers without having corresponding reference numbers in the csv file. (The filter should be included as before).

I think that there are basically two ways to do this:

1. executable (in that case I prefer c#) which will run on the local windows computer where the CSV File will be generated all the time when stock changes happened. The updates should then be done on the remote hosted prestashop webshop.

2. A php file which will be hosted on the same remote host like the prestashop webshop and gets the csv file from another webserver where it can be downloaded (or it can be also automatically uploaded)

There should be also a logfile for any update which has been done automatically.

So, basically it is just a csv file to mysql file update with a few filters, logfiles and checks.

Hopefully all details are clear, if not, please don’t hesitate to ask me.

The project name should be more "UPDATE of product combinations quantity" instead of import - sorry about that, but however, should be still the same project.

Also, when the stock quantity of a product changes of course the product itself should change the view status in the webshop or write a logfile to see which product run out of stock or another possibility is to let it online available with no stock and no price for two more weeks and then disable it - this should be just one more sql update statement.

just added a more detailed specification - looks huge, but it is just very detailed to avoid any confusion - basically it is just updating mysql database of prestashop with data out of a csv file

C# Programming MySQL

Project ID: #5277959

About the project

17 proposals Remote project Active Feb 20, 2014

Awarded to:

trustus

Hello, You will be able to directly communicate with our technical expert. Please find below URLs of recent .NET projects developed by our technical experts: [login to view URL] [login to view URL] [login to view URL] www. More

$144 USD in 7 days
(34 Reviews)
6.6

17 freelancers are bidding on average $279 for this job

gopalvora

Hi Ready to start this work.. i have more then 6 year experience in this fields.. i have already worked about this skilled Joomla , Php , Open cart , Wordpress , Drupal , Javascript , cake Php , Smarty , O More

$185 USD in 8 days
(107 Reviews)
6.7
brycep

Hi, Prestashop expert and already worked on similar project. Please provide CSV sample, so can take a look. Thanks!

$250 USD in 8 days
(50 Reviews)
6.6
shuvrapintu

A proposal has not yet been provided

$277 USD in 5 days
(124 Reviews)
6.5
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start thanks

$216 USD in 8 days
(19 Reviews)
5.3
chetanraj81lx

Hi, I am interested in this project as I have already done csv import and export work for joomla, drupal, etc. Awaiting for your response. Thanks

$155 USD in 3 days
(8 Reviews)
4.9
malexc

A proposal has not yet been provided

$333 USD in 3 days
(3 Reviews)
4.9
goswamiarpit475

Hi, i have designed many CSV updater u can check my profile for details. we can discuss in chat for more details Thanks Arpit

$66 USD in 5 days
(13 Reviews)
4.7
phpmysqlrocks

Hello Sir/Madam, i m chirag from webseek infotech web development i m having a 7 years in web development. i can work in Joomla opencart PHP Magneto WordPress Flash Flash games Android IOS and other platform as w More

$245 USD in 5 days
(15 Reviews)
4.6
murtaza1981

Hi, An ASP.NET,c#,vb and SqlServer expert here. Please feel free to discuss the project with me so that i can wrap it up in a timely manner as per your requirements. I would like to highlight following qualities of m More

$450 USD in 10 days
(9 Reviews)
4.0
probytes

Hello, I hope you are doing well, I have gone through your requirement and understands that you want to update your products with there description regularly (partial updates) as well as Weekly/Monthly (Full upda More

$277 USD in 3 days
(1 Review)
1.4
BlackmarkTech

A proposal has not yet been provided

$244 USD in 30 days
(0 Reviews)
0.0
linuxsqlvoipvpn

A proposal has not yet been provided

$250 USD in 30 days
(0 Reviews)
0.0
danchoe2011

A proposal has not yet been provided

$1030 USD in 7 days
(0 Reviews)
0.0