Manually importing orders by CSV
FlavorCloud supports manual order imports by CSV, making it easier for merchants to manage their international shipments. While we provide a CSV template, merchants unfamiliar with APIs may need guidance on specific fields.
Automatic order importing occurs when the FlavorCloud App is connected to an ecommerce platform like Shopify or through our API.
Key Considerations
- State and Country Code Field: Always use state and country codes instead of full names. Using names may prevent FlavorCloud from shipping the order or result in higher shipping rates.
- Expandable Product Fields: If an order contains multiple pieces, duplicate the relevant headers with an incremented piece number (e.g., Piece1_Quantity, Piece2_Quantity). Orders without multiple pieces or items can leave extra entries blank.
- Avoid using “#” or “,” in the csv: Due to how the csv is read when uploaded, special characters like the pound sign and commas cause errors on upload. Remove these from the CSV before uploaded.
Steps to Import an Order
- In the FlavorCloud App, Go to the Orders Grid.
- Navigate to the Order Import Menu
- Download the CSV template.
- Fill out the details following the guidelines below.
- Upload the completed CSV to FlavorCloud.
Important Import Options
- Import As Rated: Setting this to True applies the terms of trade and service level in the CSV to attempt to retrieve a shipping rate.
- Import As Fulfilled: Setting this to True will both attempt to rate and fulfill the order using the informaiton provide in the CSV. This option overrides the “Import As Rated” setting.
- Default Data Handling: If certain data is missing, FlavorCloud will attempt to use your default account settings to process the order.
Adding multiple items to an order
To add multiple items to an order you can fill out just the item or piece information and add additional rows for additional items. Fill out the field names that include “Piece” information with each row representing each item in the order. The rows will connect with the last previous address information in the CSV.
Fields:
| Field Name | Values/Guidance |
| Reference | Unique value for your store to reference an order |
| ReasonForExport | This field is for your reference and must be unique. It is advised to provide your order number here. Duplicate Reference values may not be provided. |
| Address_Name | Name of person. Both name and company can be included |
| Address_AttentionName | Name of attention, if person |
| Address_AddressLine1 | First line of the address |
| Address_AddressLine2(Optional) | Second line of the address if needed |
| Address_AddressLine3(Optional) | Third line of the address if needed |
| Address_City | Full city name |
| Address_StateCode | State or province code |
| Address_Zip(Optional) | ZIP or postal code |
| Address_CountryCode | (ISO 3166 country code)[ https://www.iso.org/obp/ui/#search/code/] for the country the address is located in |
| Address_Phone | Phone number to reach the person or organization |
| Address_Email | Email to reach the person or organization |
| Piece_Quantity | Quantity of pieces or items you are shipping |
| Piece_Weight | Weight of each individual piece |
| Piece_SalePrice | SalePrice of each individual piece |
| Piece_HSCode | Harmonized Tarriff Code of piece |
| Piece_OriginCountryCode | ISO 3166 country code for the country the piece was manufactured in |
| Piece_Description | description of the piece you are looking to ship |
| Piece_SKU(Optional) | SKU of piece |
| EmptyPackage_Weight | Empty package weight without pieces added |
| Package_Length | Length of Package |
| Package_Width | Width of Package |
| Package_Height | Height of Package |
| ServiceLevel(Optional) | STANDARD or EXPRESS |
| TermsOfTrade(Optional) | DDU or DDP |
| WeightUnit(Optional) | LB or KG, will be used for all weights within order import |
| Currency(Optional) | Currency code for the order, IE: USD |
| DimensionUnit(Optional) | IN or CM |
| Insurance(Optional) | Y or N |
| Transaction Type(Optional) | B2b or B2c |
| ImportAsRated(Optional) | True or False |
| ImportAsFulfilled(Optional) | True or False |