In Progress

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

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

Skills: C# Programming, MySQL

See more: import combination csv prestashop, where can i find format, remote full time php, reference letters, letters of reference, has been changed, 48 hour code, format price, stock update, prestashop update, prestashop import, prestashop email, prestashop case, import two, changed, update quantity prestashop, update mysql csv php, csv php prestashop, csv product import, webshop mysql, prestashop product quantity, mysql import remote file, can log reason, csv update, update stock reference prestashop

About the Employer:
( 1 review ) Spain

Project ID: #5277959

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: [url removed, login to view] [url removed, login to view] [url removed, login to view] www. More

$144 USD in 7 days
(34 Reviews)
6.6

17 freelancers are bidding on average $279 for this job

SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$144 USD in 3 days
(69 Reviews)
6.8
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
Hariomtechnology

Hello , We are one of the best programming team on freelancer. We have more than 91+ Client Reviews (Feedbacks). Please check our profile here: [url removed, login to view] Please see some of More

$257 USD in 9 days
(22 Reviews)
6.1
snehaworks

Hello, I have gone through the description, can you give me sample csv to look at? Do you have the remote server's ftp details from where you want to get the csv? I will provide you the cronjob which will run every More

$266 USD in 7 days
(21 Reviews)
6.0
dinastalb

Hello, I am Van Qaqi. I work with my partners Rolland, Chris and Joe at Netronian Inc., in Orlando, Florida. We have great experience with Web Development. 80 percent of our developed websites are eCommerce websi More

$2060 USD in 30 days
(7 Reviews)
5.7
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
zamsol

You are looking to convert the CSV into prestashop 1.5 website. We can easily develop & customized the theme in prestashop. We have seen the reference features. We have manage the following services such as -Full Upda More

$206 USD in 8 days
(4 Reviews)
2.5
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
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
BlackmarkTech

A proposal has not yet been provided

$244 USD in 30 days
(0 Reviews)
0.0