- Old Reports
- Sales
- ShipCompliant 1011
ShipCompliant 1011
This page documents an older/sunset version of our reporting tools - for documentation on the latest version click here.
For those using ShipCompliant for their compliance needs, the ShipCompliant 1011 Report allows you to export order data in the necessary format for the ShipCompliant team to work with.
We have a few parameters you can use to export the ShipCompliant 1011 on:
- From Date
- To Date
- Date Type (Submitted/Completed/Ship/Pickup/Modified)
Reports export in .CSV format.
Here are the definitions of what will populate in your ShipCompliant 1011 report:
| Version | Always 1011 - The version of the ShipCompliant report. |
|---|---|
| Company | Website Code (not Website Name) Your company name that the order was placed under. |
| Sales Order Key | Order number. |
| Fullfillment Order Key | Always blank. |
| Shipment Key | Always blank. |
| Club Type | Always blank. |
| Sub Club | Always blank. |
| Pickup | Is the order for pickup? (Yes = 1, No = 0) |
| Three Tier | Always blank. |
| Reserved 1 | Always blank. |
| Reserved 2 | Always blank. |
| Reserved 3 | Always blank. |
| Reserved 4 | Always blank. |
| Billing Last Name | Last name of the customer that is being billed. |
| Billing First Name | First name of the customer that is being billed. |
| Billing Company | Company name of the customer that is being billed. |
| Billing Address1 | Address of the customer that is being billed. |
| Billing Address2 | Secondary address information of the customer that is being billed. |
| Billing City | City that the customer being billed lives in. |
| Billing State | State code that the customer being billed lives in. (XX) Ex: California - CA |
| Billing Zip | Zip code/Postal of the customer that is being billed. |
| Billing Date Of Birth | Birthdate of the customer that is being billed. (MM/DD/YYYY) |
| Billing Email | Email address of the customer that is being billed. |
| Billing Phone | Phone number of the customer that is being billed. |
| Sales Type | Always offsite. |
| Order Type | Club or Internet. |
| Customer Number | The customer 32 digit unique identifier. |
| Payment Date | The date that the order was placed on. (MM/DD/YYYY) |
| Shipping Last Name | Last name of the customer that the order is being shipped to. |
| Shipping First Name | First name of the customer that the order is being shipped to. |
| Shipping Company | Company name of the customer that the order is being shipped to. |
| Shipping Address1 | Address of the customer that the order is being shipped to. |
| Shipping Address2 | Secondary address information of the customer that is being billed. |
| Shipping City | City that the customer lives in that the order is being shipped to. |
| Shipping State | State code that the customer lives in where the order is being shipped to. (XX) Ex: California - CA |
| Shipping Zip | Zip code/Postal of the customer that the order is being shipped to. |
| Shipping Country | Always blank. |
| Shipping Date Of Birth | Birthdate of the customer that the order is being shipped to. (MM/DD/YYYY) |
| Shipping Email | Email address of the customer that the order is being shipped to. |
| Shipping Phone | Phone number of the customer that the order is being shipped to. |
| Carrier Service | The shipping carrier for the order (UPS/FedEx/GSO/etc.) |
| Ship Date | The date the order is physically shipped. (MM/DD/YYYY) |
| Freight Cost | The total amount of shipping. |
| Tracking Number | A unique number assigned to each shipment, used for tracking purposes. |
| Sample Type | Always blank. |
| Age Check ID | Always blank. |
| Discount Amount | The discounted amount applied to the order shown in dollars. |
| Discount Percent | The discounted amount applied to the order shown as a percentage. |
| Reserved 6 | Always blank. |
| Reserved 7 | Always blank. |
| Reserved 8 | Always blank. |
| Fullfillment House | The company name who will fullfill the order. |
| Shipment Status | The shipping status of the order. (Shipped/SentToFullfillment/PendingCarrierPickup/etc.) |
| Licensed Relationship | Always SupplierToConsumer. |
| Insured Amount | Always blank. |
| Sales Tax Charged | Total amount of tax. |
| Handling Fees | Total amount of handling. |
| Gift Note | Gift Message - Message written by customer to go along with order. |
| Special Instructions | Always blank. |
| Brand Key | Always blank. |
| Product Key | Product SKU. |
| Quantity | The quantity purchased. |
| Unit Price | The price per unit for the SKU being sold. |
| Weight | The weight of the product. |