Order ID - the alphanumeric identifier used to mark your orders in MarginDriver. If you use an order management system that centralizes all of your orders and assigns them with a unique identifier, it is wise to use the same identifier for this field. If your orders are coming directly from a marketplace or ecommerce platform, use this ID, which you will also use for the Site Order ID field.
Order Site Name - the sales channel name used to identify this channel in MarginDriver. Use a unique name for each sales channel and use it for all orders on from that sales channel.
Order Site Profile*** - a value populated by MarginDriver when two sales channels have matching origins. Only populate this field if a value has been already been assigned by MarginDriver on the Sales Channels and Integrations page.
Site Order ID - the ID of the order from the sales channel where it was placed (Amazon, eBay, Shopify, etc). If you do not have a centralized order management system, this ID will also be used in the Order ID field above.
Order Date - the date the order was placed. The correct format is MM/DD/YYYY.
Shipping Date*** - the date the order was shipped (if it has been shipped already). The correct format is MM/DD/YYYY.
Checkout Status - indicates whether payment has been completed for the order. Enter Completed for ALL orders.
Shipping Revenue - payment the seller took in from the customer to cover shipping cost.
Sales Tax - payment the seller took from the customer to cover sales tax (not necessarily the actual sales tax owed by the seller to the taxing authority).
Discounts - discounts applied to the order at checkout. This value is not included in the value you enter into the product revenue or shipping revenue. This value is primarily provided to explain why your margins may be lower than expected for certain orders.
SKU Number - a unique alphanumeric identifier for each unique product.
Product Cost Per Unit - the seller's cost per each individual unit of a SKU sold.
Product Brand*** - the brand of the product sold.
Product Title*** - the title of the product sold.
Product Price Per Unit - sales revenue per each individual item of SKU sold.
Product Quantity - the number of units sold per SKU.
Distribution Center ID*** - third party distribution center ID
Distribution Center Name*** - name of the distribution center, warehouse or dropshipper where the order was sourced and shipped from.
Distribution Center Code*** - a short 1-2 letter abbreviation for the Distribution Center Name. This is the distribution center field that will appear in MarginDriver reports.
Shipping Country*** - shipping destination country
Shipping State or Province*** - shipping destination state or province (2-letter abbreviation)
Shipping Carrier*** - e.g., UPS, USPS, FedEx, DHL, etc.
Shipping Class*** - e.g., First Class, Ground, SmartPost, Global Mail, etc.