Brand Supplied Data: Adding Other Orders

If you have other sales in addition to Shopify and Amazon, you can enter those sales into the Other Orders tab of the Brand Supplied Data template. 

Orders entered here can be D2C or B2B. 

Attributes that can be included are below (* indicates column is required).

Order Date / Column B*

The date you wish to record the transaction occurring. 

Order ID / Column C*

This is the unique order identification number that you or your system uses to identify or look up the order. This should be unique for each individual order. 

Order Line ID / Column D*

If the order contains multiple items, each individual item should have a unique identifier, enter that here.

SKU / Column E*

Enter the SKU for the item in the order.

$ Product Price / Column F*

This should be the full retail selling price of the product, not including any discounts applied, as discounts will be recorded as a separate attribute.

Quantity / Column G*

The number of identical items in that particular order.

$ Discount / Column H

The discount, if any, that was applied to the item in the order. 

$ Tax / Column I

The tax applied to the order.

$ Shipping Amount Paid / Column J

The amount, If any, the customer paid for shipping.

Email / Column K

The email associated with the customer. If you have this information for the end customer, that Is ideal. This information is used in householding and identifying the same customer who buys through multiple channels.

Customer Name / Column L*

The name of the customer. This can be a person, organization or company (I.e., Sally Smith or Nordstrom).

Country / Column M

The country the order is from. You may add additional countries by updating the Congfiguration sheet of the template. 

Business Channel / Column N*

Choose either Direct to Consumer if the order is from an end customer or Business to Business if this is a wholesale order.