Import, alter and export csv file
$30-250 USD
Paiement à la livraison
We have an existing system which changes the output file from our website (Runs on Creloaded/OsCommerce) to the format required to import into another system.
We now need to improve this export, either updating the existing process or with a new process. The new output will deal with more records but will have roughly the same process.
To build the new output file the process can either use the "custom export" module from MagneticOne onto our Creloaded web store:
[url removed, login to view]
or alternatively modify the Google Base export file which is already in use:
[url removed, login to view]
The next step is to output the fields in the correct format, which is:
SKU Barcode CatNum (Same as SKU) Title Quantity (Fixed at 5) Cost
Barcodes must be in 13 digits Number format, with 0 decimal places. If the barcode does not meet this criteria it must be removed and replaced. For these barcodes there must be another table created which links the SKU and the barcode so that the same barcode is exported for each SKU each time.
Title must be in Sentence case
Cost must be a formula, to be * a percentage as set in the web store
The output file then needs to be uploaded by FTP to a different server around 7AM GMT each day.
If you can do this project please let me know.
Thanks
Nº du projet : #1311079
À propos du projet
9 freelances font une offre moyenne de 117 $ pour ce travail
We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.
Expert PHP/MySQL developer with over 6 years of experience. Ready to start immediately and finish within several hours.