Project ID:
469512
Project Type:
Fixed
Budget:
$30-$250 USD
Project Description:
someone will need to create is the following:
A small executable program that will:
1) take an x-cart order export csv file
2) tranform it into the proper mom(mail order manager) import format which is .dbf
We need someone who has done this before.
For example, the dbf can’t contain headings, but the 10th column needs to be the zipcode. Column 22 is the “Source_key”. Depending on which site exports orders, the source key will be different. If we are exporting from our canadian site, the source key will be "CANADA" -- if we are exporting from our Uk site, the source key will be "CUFFSUK". Also, please note, when reviewing the File Structure document please make sure you read about column 30, which is “Continued”, and it is very important.
ive attached an example dbf, the file structure for a dbf and also an example x-cart orders export.
thanks!
Skills required:
Excel,
PHP,
Shopping Carts,
Visual Basic,
XML
Additional Files:
File Structure for CSV.docx
sample_from_xcart.csv
example.DBF