Project description
We run an online store and receive regular price lists from several suppliers in Excel and CSV format. Updating our catalogue by hand takes an entire day each week, mistakes creep in, and prices on the site lag behind reality. We are looking for a developer to build a script that imports these supplier price lists into our store automatically and keeps prices and stock levels accurate.
The script needs to read a file in the supplier own layout, match each incoming row to the right product in our catalogue by article number or barcode, and then update the price and the quantity in stock. New positions that do not yet exist should be reported separately rather than created blindly, so we can review them first. When a product disappears from the supplier feed, its stock should drop to zero instead of staying available.
Reliability matters more than speed here. Every run must write a clear log that shows how many rows were processed, how many were updated, which ones could not be matched and why. We would like to launch the import on a schedule and also by hand when a fresh price arrives. Please account for different column orders between suppliers and for decimal and encoding differences in their files.
The script needs to read a file in the supplier own layout, match each incoming row to the right product in our catalogue by article number or barcode, and then update the price and the quantity in stock. New positions that do not yet exist should be reported separately rather than created blindly, so we can review them first. When a product disappears from the supplier feed, its stock should drop to zero instead of staying available.
Reliability matters more than speed here. Every run must write a clear log that shows how many rows were processed, how many were updated, which ones could not be matched and why. We would like to launch the import on a schedule and also by hand when a fresh price arrives. Please account for different column orders between suppliers and for decimal and encoding differences in their files.
Web programming Cash, Bank transfer
