Shipium Initial Data Upload

Hello and welcome to Shipium! We are looking forward to working with you to make things better for your customers. In order to get started, we will use an initial set of your historical orders to prime our systems.

REMINDER: PLEASE DO NOT INCLUDE ANY CUSTOMER-IDENTIFIABLE DETAILS SUCH AS NAME, EMAIL ADDRESS OR CREDIT CARD (OR OTHER BILLING) INFORMATION.

Please note that if you run into any problems or have a question, you should not hesitate to reach out to your Shipium contact or email integrations@shipium.com for support.

 

Preparation

In order to get started, you will need to pull 6-12 months of basic shipping data. You can go to the sample excel file (SamplePartnerUpload.xlsx) as an example template. An appropriately formatted CSV or tab-delimited file is also fine if that is easier. The bottom of this page details the columns.

 

Uploading Your Data

When you are done preparing the data, please use the below link to upload it to us via Google Business secure file transfer.

➜ Shipium Secure File Upload

 

Required Columns and Data

These data are needed for each unit that shipped during the 6-12 month period.

  • Customer Country - The 2-letter country code for your customer’s shipping address.

  • Customer Postal Code - The country-specific postal code for your customer’s shipping address.

  • Ships from Country - The 2-letter country code for the shipping warehouse.

  • Ships from Postal Code - The country-specific postal code for the shipping warehouse.

  • Ordered Timestamp - Date & time that your customer ordered the item.

  • Shipped Timestamp - Date & time that your fulfillment center shipped the item to your customer.

  • Product ID - Your product ID for this product.

  • Carrier Name - The carrier for your customer’s outbound shipment (e.g. UPS, FedEx).

  • Carrier Tracking ID - Carrier-specific tracking identifier.

  • Delivery Timestamp - Date & time that the carrier delivered the product to your customer.
    Note: If you do not have delivery timestamps, we can likely pull this information for you. Just let us know.

Optional Columns and Data

The information below is nice to have for certain analyses, but is not required for initial onboarding.

  • Product Category - A Partner-specific category for the product (e.g. “book”).

  • Package Linear Unit - The unit for height, width and length. One of “FT”, “IN”, “M”, or “CM”.

  • Package Height - The linear height of the package in package_linear_unit(s).

  • Package Length - The linear length of the package in package_linear_unit(s).

  • Package Width - The linear width of the package in package_linear_unit(s).

  • Package Weight Unit - The unit of weight for package_weight. One of “LB”, “OZ”, “KG” or “G”.

  • Package Weight - The weight of the package in package_weight_unit(s).

  • Packaging Type - Type of packaging used to ship the product.
    “BOX”, “BAG” and “TUBE” are the valid values.

  • Is Dropship - “true” if the product was drop-shipped. “false” otherwise.