Sending Amplifier your Orders outlines the process of how to send us your orders. This article reveals more detailed insights into loading orders via a batch Import using the template.
Unit Prices
Though not all fields are required, we recommend that you provide all applicable data, particularly the sales price as UnitPrice.
If provided, UnitPrice will determine the declared value for all international shipments for the purposes of customs declaration.
If not provided, the item's configured price in the order will be set to $1. The good news is that the import will not fail because you left this field empty. The bad news is that this international order will likely be flagged by customs officials for review since the likelihood of the item truly being priced at $1 is very low, which in turn will cause delays.
UnitPrice will determine how taxes are applied by the destination country's customs office, so make sure that is accurate and complete in your order data.
Orders With Multiple Line Items
For orders containing multiple items, the related customer information must be included on the adjacent lines.
As a final step, it is also worth sorting by OrderID, as our system will ignore any non-adjacent items as a duplicate order.
** It is incredibly important that your data be accurate. **
You are responsible for the accuracy of your data.
Please validate your import.
Did it import the right number of orders?
On review, do your orders look accurate and complete?
Once orders are successfully imported, there is no guarantee that we will be able to stop fulfillment in the event of an error in your order data.
As such, take the time to thoroughly review your .csv file before attempting to import.
Failed Imports
If your CSV file contains formatting errors, Amplifier will let you know exactly what failed and why in the Import Status screen. Understanding the required values will keep those failures to a minimum.
If one or more orders fail import, just click the flag in the "FAILED" column on the Import Status page.
You will be provided feedback for any values that failed validation.
Click the "Download Failed Orders" button at the bottom of the Import Failures summary to download the consolidated list or failed orders.
Just correct the issues and attempt import again as needed.
Tips when errors occur:
Check your file extension - it must be csv (not Excel .xlsx)
Rather than exporting your orders from your ecommerce site and using that file as the basis for the Order Upload Template, organize your data in that export file so it's in the correct order. Then, copy just the information needed and paste values only into a freshly downloaded copy of the template. That way, you don't include extra, unnoticed data off to the right of the dataset or below your intended last row of data.
Regarding Amplifier Client Service and Imports
If you have questions or encounter issues, you may contact Amplifier at help@amplifier.com.
Amplifier does not handle CSV imports for clients because clients need to own this validation step, having full access to their original order source and the generation of this data.
Clients have successfully imported order data thousands of times. The largest import included over 37,000 shipments and had to be imported in five pieces given file-size limits.