Easily streamline your shipping process by importing order data directly into Ship&co using a CSV file. This feature is especially useful for bulk order management from a platform that Ship&co doest no integrate with, allowing you to upload multiple orders at once, saving time and reducing manual entry errors.
To upload a CSV of your orders data into Ship&co, click on "import csv", in the Orders List Page in Ship&co App.
To ensure a smooth import process, it's important to use our standardized CSV template, which is designed to meet all the necessary formatting and data requirements. By using our template, you can avoid common issues and ensure that your order data is correctly processed in Ship&co.
You can download the template CSV file at the bottom of this page. Follow the detailed guide below to correctly fill out each field in the CSV file. The maximum number of orders (OrderName) that can be imported in a single CSV file is 200.
| Column Name | Description | Format/Allowed Values | Note & Example |
|---|---|---|---|
| OrderName | Required data entry: order number (if you are buying multiple pieces, please fill in the order number for all items) | Ex: add here the order number from your store. It usually appears on the shipping label. ※-1 | |
| ReferenceNumber | Optional data entry: reference number different from the order number when needed | Can be used to add a number different from the Order Number when needed | |
| CurrencyCode | Required data entry: currency code | ISO alpha-3 (3 digits) | Ex: EUR or USD |
| RecipientProvince | Optional data entry (if the country has states/provinces etc): code of the state/province | ANSI standard (2 letters). Example: California= CA, New South Wales= NSW |
|
| RecipientCountryCode | Required data entry: country code | ISO alpha-2 (2 digits) | e.g., US, JP, FR, etc. |
| RecipientZIP | Required data entry: zip code | For countries without zip code (Hong Kong, Ireland etc), please enter 000 in lieu of the zip code. | |
| RecipientFirstName | Optional data entry: recipient's first name | Max 35 letters | |
| RecipientLastName | Optional data entry: recipient's last name | Max 35 letters | If the Recipient Company is left blank, this field MUST BE FILLED IN. |
| RecipientPhone | Required data entry: recipient's phone number | Up to 10 digits | There's no need to include the country code (e.g., '+1') as the phone number is intended for local delivery use. |
| RecipientAddress1 | Required data entry: recipient's address | Up to 35 letters | For DHL, FedEx, and UPS: English is required. For JapanPost (International): English or Chinese is accepted. For Sagawa, Yamato, and JapanPost (Domestic): The address must be in Japanese. |
| RecipientCity | Optional data entry: name of the recipient's city | Max 30 letters | |
| RecipientCompany | Optional data entry: name of the recipient company | Max 30 letters | If the Recipient Last Name is not provided, this field must be completed. |
| RecipientTaxId | Optional data entry: recipient's tax ID for international orders | You can add Tax IDs (such as VAT ID, EORI, etc.) for the consignee or importer in international orders. Currently supported for JapanPost International, Pegasus, UPS, Fedex and DHL. | |
| Date | Optional data entry: date when the order was placed | e.g., "2024-09-25" | |
| RecipientMail | Optional data entry: email address of the recipient | Max 30 letters | e.g.," test@shipandco.com" |
| RecipientAddress2 | Optional data entry: Recipient Address 2 | Max 35 letters | |
| DeliveryNote | Optional data entry: delivery note or short message about the shipment | Usually appears on label or invoice depending on carrier, to add a short message about the shipment | |
| ProductDescription | Required data entry: product/brand name | e.g., "Recipe Book" | |
| ProductQuantity | Required data entry: product quantity | e.g., "2" | |
| ProductPrice | Required data entry: product price | Format: xxxx.xx | |
| ProductHSCode | Optional data entry: product HS code | 6-15 digits | e.g.,"3924.10" ※-3 |
| ProductHSDescription | Optional data entry: description of the product's HS code | Material properties of the goods | e.g.,"Plastic Kitchenware" ※-3 |
| ProductCountryCode | Optional data entry: production country's code | e.g.,"JP" ※-3 | |
| Parcel Width | Optional data entry: parcel width | cm or in, depending on your settings in Ship&co. | E.g., 20 |
| Parcel Height | Optional data entry: parcel height | cm or in, depending on your settings in Ship&co. | E.g., 15 |
| Parcel Length | Optional data entry: parcel length | cm or in, depending on your settings in Ship&co. | E.g., 20 |
| Parcel Weight | Optional data entry: parcel weight | g, kg, oz or lbs, depending on your settings in Ship&co. | E.g., 2500 |
| Parcel Amount | Optional data entry: number of parcels | Only when compatible with the shipping service. | E.g., 2 ※-4 |
| Signature | Optional data entry: request signature at the delivery | True or False | |
| DeliveryDuty | Optional data entry: delivery duty | DDU or DDP | If it is left blank, DDU ▫ ). For Incoterms, （DDP = ☑ , DDU = ▫ ). |
| Discount | Optional data entry: discount | Discount rate % (0~100) | If it is left blank, it is without a discount. |
| InsuranceAmount | Optional data entry | Only for FedEx, DHL, UPS or JapanPost Int. | E.g., 500 |
| ShippingMethod | Optional data entry: name of Shipping Method, carrier service | The name of the shipping method will appear in Ship&co order page for your information only | E.g., "FedEx IP" |
| ShippingFee | Optional data entry: Shipping cost value | The cost will appear in Ship&co order page for your information. It's used on International Customs invoice | |
| ShippingDate | Specifies the shipping date - Japan domestic only | YYYY-MM-dd | If left blank, the current date will be used. |
| DeliveryDate | Specifies the desired delivery date- Japan domestic only | YYYY-MM-dd | If left blank, no delivery date will be saved. If provided, it must be at least one day after the ShippingDate. |
| DeliveryHour | Preferred delivery time window- Japan domestic only | 'Anytime', 'AM', '12-14', '14-16', '16-18', '18-20', '18-21', '19-21', '20-21' - Yamato: For "time" service, only '10am' and '5pm' are allowed. | Ensure the correct time window is selected based on the carrier being used. |
| ServiceName | Type of service used with Yamato- Japan domestic only | 'regular', 'collect', 'direct_mail', 'time', 'freight', 'nekopos', 'taqbin', 'taqbin_collect' | Only applicable for Yamato. If the carrier is not Yamato, the value will not be saved, and no error will be thrown. If a value is provided here and no Carrier is set, 'yamato' will be automatically assigned as the carrier. |
| ServiceType | Type of service (e.g., regular, chilled) - Japan domestic only | 'regular', 'chilled', 'frozen', ('plane' for Sagawa) | Only applicable for Yuupack, Yamato, and Sagawa. If another carrier is used, the value will not be saved, and no error will be thrown. If no value is set, the system will use the carrier's default service type or fallback to 'regular'. |
| IsCod | Indicates whether the shipment is Cash on Delivery (COD)- Japan domestic only | true, false | COD-related fields (`IsCod`, `CodAmount`, `CodTaxAmount`) are only applicable for Yuupack, Sagawa, and two Yamato services ('collect' and 'taqbin_collect'). |
| CodAmount | Specifies the amount to be collected for COD orders- Japan domestic only | Numeric - JPY | Only applicable for COD shipments. E.g., "5800" |
| CodTaxAmount | Specifies the tax amount included in the COD total- Japan domestic only | Numeric - JPY | Only applicable for COD shipments. E.g., "580" |
| CarrierName | Specifies the carrier handling the shipment | 'ups', 'fedex', 'yuupack', 'yamato', 'sagawa', 'dhl', 'japanpost', 'yuupacket' | Ensure this matches the correct carrier code. |
※-1. When an order contains multiple products, the following fields become required for the 2nd row and beyond**:** OrderName, ProductDescription, ProductQuantity, ProductPrice
※-2. For RecipientProvince: For countries with state codes such as the US, Canada, and Australia, please enter the state code. For countries without state codes, enter the regional name (prefecture name for Japan). For US destinations, CSV import will work without state codes, but please note that an error will occur when generating shipping labels.
※-3. For ProductHSCode, ProductHSDescription, ProductCountryCode: If the combination entered for these fields does not exist in Ship&co's "Settings" screen >> "Product List", the CSV upload will automatically overwrite the "Product List".
※-4. When shipping multiple parcels, you can enter the quantity in "ParcelAmount". However, unfortunately, the CSV upload format does not support entering multiple parcels of different sizes. Even if you input data as shown above, only the information from the top row will be reflected in the application. In this case, we apologize for the inconvenience, but please add/edit additional parcels manually after uploading the data by using the [Add Parcel] function in the "Parcel Details" section of the order management page in the application.
Comments
0 comments
Article is closed for comments.