SKU-Based List for Backer Information Template
For exporting information from your pledge manager, SKU-based.
- What it is
- An Excel template for backer shipping data organised by product SKU (stock keeping unit), with worked examples.
- Who it's for
- Creators whose backers ordered different combinations of products, such as a base game, expansions and add-ons.
- What's inside
- Three sheets: the template (order number, recipient and address, tax or PCC code, product SKU and quantity, and customs declaration fields such as declared value and HS code), an explanation, and examples.
- How to use it
- Fill in one row per SKU per order, then send it with your fulfilment request.
Excel spreadsheet (.xlsx)
Preview — sheet "Sheet1": 7 of 7 rows.
| Order No. | Recipient Full Name | Country Code | Province/State Name | Province/State Code | City Name | Address 1 | Address 2 | Zip Code | Recipient Company | Phone Number | Tax number/PCC Code | Product SKU | QTY | Declared Chinese Name | Declared English Name | Declared Value(USD) | Declared Value(EUR) | HS Code | Material | Purpose | Note |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Bulk import order function description | |||||||||||||||||||||
| A | These fields are required | ||||||||||||||||||||
| A | These fields are optional | ||||||||||||||||||||
| 1.If an order contains multiple types of products, fill in multiple lines.ensuring that Order No.,Recipient Full Name,Country Code,City Name,Address 1,Zip Code,Phone Number are all consistent 2.A maximum of 1000 pieces of data can be imported at a time. | |||||||||||||||||||||
| An order contains multiple types of products/ | |||||||||||||||||||||
| A002 | Full Name | UK | London | 221 | 231212 | 111111 | IP-64G-RED | 1 | |||||||||||||
| A002 | Full Name | UK | London | 221 | 231212 | 111111 | IP-128G-RED | 3 |
Preview — sheet "Example": 7 of 7 rows.
| An order contains one type of product/ | |||||||||||||||||||||
| Order No. | Recipient Full Name | Country Code | Province/State Name | Province/State Code | City Name | Address 1 | Address 2 | Zip Code | Recipient Company | Phone Number | Tax number/PCC Code | Product SKU | QTY | Declared Chinese Name | Declared English Name | Declared Value(USD) | Declared Value(EUR) | HS Code | Material | Purpose | Note |
| A001 | Full Name | UK | London | 221 | 231212 | 111111 | IP-64G-RED | 2 | |||||||||||||
| An order contains multiple types of products/ | |||||||||||||||||||||
| Order No. | Recipient Full Name | Country Code | Province/State Name | Province/State Code | City Name | Address 1 | Address 2 | Zip Code | Recipient Company | Phone Number | Tax number/PCC Code | Product SKU | QTY | Declared Chinese Name | Declared English Name | Declared Value(USD) | Declared Value(EUR) | HS Code | Material | Purpose | Note |
| A002 | Full Name | UK | London | 221 | 231212 | 111111 | IP-64G-RED | 1 | |||||||||||||
| A002 | Full Name | UK | London | 221 | 231212 | 111111 | IP-128G-RED | 3 |
More in Logistics
Shipping and Fulfillment Fundamentals by Prime Ship
If you have no idea how shipping and fulfillment works, start here.
Download →Address-Based List for Backer Information Template
For exporting information from your pledge manager.
Download →Special Country Requirement for Fulfillment
Prepare your backer information as needed in advance.
Download →