Requirements
A .xlsx, .xls or .csv file containing orders and order items
The file must be up to 100 rows
Introduction
This manual is intended to provide detailed specifications and validation rules for each column in the file format used for uploading orders to ehouse. Adhering to these rules will ensure a smooth and error-free upload process.
Column Types
Mandatory Columns
These columns are essential for the order to be processed in the system. Missing or wrong data in these columns will prevent the order from being uploaded.
Recommended Columns
These columns are not mandatory but provide crucial information for better order processing. Missing or wrong data in these columns won't prevent the order from being uploaded, however, the cell itself will be skipped.
Optional Columns
These columns can be included for additional information but are not required for order processing. Missing or wrong data in these columns won't prevent the order from being uploaded, however, the cell itself will be skipped.
Additional Guidelines
Ensure that the file does not contain extra spaces before or after the text in each cell.
Avoid using special characters in fields unless specified in the validation rules.
Ensure that dates and decimals are formatted according to the specified validation rules.
Troubleshooting Common Validation Issues
Incorrect Formats: Recheck the data against the validation rules. Incorrect formats often lead to upload errors.
Missing Mandatory Data: Ensure all mandatory columns are filled. Missing data in these columns will prevent the file from being processed.
Contact Support
For further assistance or specific inquiries, please contact our support team at [email protected].
Column name | mandatory/recommended/optional | Guidelines | Example |
Order Number | mandatory | Free Text | #1000 |
Order Date | recommended | YYYY-MM-DD | 2023-10-07 |
Company | optional | Free Text | My Company |
Receiver Name | mandatory | Free Text | My Name |
recommended | Free Text | ||
Phone | recommended | Free Text | 509999999 |
Address | mandatory | Free Text | AddressOne |
Address 2 | optional | Free Text | AddressTwo |
City | mandatory | Free Text | My City |
State/Province | recommended | 2 Letters State Code | CA |
Zip/Postal Code | mandatory | Free Text | 90210 |
Country Code | mandatory | 2 Letters Country Code | US |
Receiver Comment | optional | Free Text | Apartment 5 |
Merchant Comment | optional | Free Text | Pack with care |
Customer Comment | optional | Free Text | Happy birthday |
number of Packages | recommended | Valid Number (Int or Decimal) | 1 |
Package Weight | recommended | Valid Number (Int or Decimal) | 0.5 |
Package Weight Unit | recommended | Valid Weight Unit (kg/lbs/gm/oz) | kg |
Package Length | recommended | Valid Number (Int or Decimal) | 2.3 |
Package Width | recommended | Valid Number (Int or Decimal) | 2.3 |
Package Height | recommended | Valid Number (Int or Decimal) | 2.3 |
Package dims unit | recommended | Valid Weight Unit (cm/inch) | cm |
Order Currency | optional | 3 Letters Currency Code | USD |
Requested Delivery method | mandatory | Free Text | home delivery 3-5 days |
item SKU | optional | Free Text | B-23-C |
item name | optional | Free Text | green shirt |
item price | optional | Valid Number (Int or Decimal) | 30.5 |
item quantity | optional | Valid Number (Int) | 5 |
ship from location | recommended | Free text | My home |