| Section Quick Links |
| Product Data | Related Products | Product Shipping Data | Pricing Data | Location & Decoration Data |
| Spreadsheet Header | Description | Example | |
| PRODUCT DATA | Previous ↑ | Next ↓ | ||
A |
supplierItemGuid | DC's unique identifier - Don't modify. For new products, leave this column blank | 0BB83607-00D7-4B2C-8695-32AD3812B6F4 |
B |
productNumber * | Your unique identifier assigned to a specific item to track it within a system | TOTE-101 |
C |
productName * | The public-facing title of your product. | Classic Canvas Tote Bag |
D |
description | A full narrative of the product’s features and benefits. | A durable, 12oz cotton canvas tote with reinforced handles—perfect for grocery shopping or trade shows. |
E |
additionalInformation | Supplemental details that don't fit in the main description, such as care instructions or safety warnings. | Hand wash only. Do not iron the imprint area. |
F |
distributorOnlyInformation | Notes intended only for the distributor (e.g., specific wholesale policies or internal codes). This information is not shown to end-buyers. | 5% discount available for orders over 1,000 units. Not available for rush shipping. |
G |
category * | The specific classification for the item. | Bags - Tote |
H |
keywords | A list of hidden search terms (separated by commas) used to help your product appear in relevant search results | canvas bag, eco-friendly, shopping tote, cotton bag, reusable |
I |
bulletPoints | Short, punchy highlights often displayed near the product image for quick scanning of key features. | Made from 100% natural cotton, 22-inch reinforced handles, Spacious 15" x 16" main compartment |
J |
originationZipCode | The postal code from which the item ships. This is essential for accurate freight and shipping estimates. | 90210 |
K |
countryOfManufactureName | The country where the product was produced (e.g., "USA" or "China"). | United States |
L |
productImageUrl | A direct link to your product image. The system uses this link to pull the image into the database. (first URL is designated as the "Primary" image) | http://test.com/test.png|http://test.com/test.png#Black |
M |
productColors | A list of available colors for the item. | Black|Royal Blue|Red|Natural |
N |
productLength | The physical length of the item itself. In inches | 15 |
O |
productWidth | The physical width of the item itself. In inches | 4 |
P |
productHeight | The physical height of the item itself. In inches | 16 |
Q |
productWeight | The physical weight of the item itself. In pounds | 0.45 |
R |
apparelSizes | Lists the sizes available. | S|M|L|XL|2XL |
S |
apparelUpcharges | Defines any price increases for larger sizes (e.g., $2.00 extra for 2XL) | 2XL=2|3XL=3 |
T |
nonDimensionalSize | Used for products that don't use standard L/W/H measurements | 16oz or 2gb |
U |
productionTime * | The standard number of business days it takes to produce the order after proof approval. | 10 |
V |
priceIncludesShipping | Indicates if the listed price is "Freight On Board" (FOB) or includes delivery. (Yes/No) | No |
W |
priceIncludesColors | States how many imprint colors are included in the base price. | 2 |
X |
priceIncludesSides | States if the price includes a 1-sided or 2-sided imprint. | 1 |
Y |
priceIncludesLocations | Indicates how many imprint locations (e.g., "Pocket" and "Sleeve") are included in the base price. | 1 |
| RELATED PRODUCTS | Previous ↑ | Next ↓ | ||
Z |
relatedSubstitute | Use this type to recommend product alternatives. | TOTE-864 |
AA |
relatedCompanion | These are products that go hand-in-hand with whats currently being viewed. | TOTE-764 |
AB |
relatedVariants | Product variations grouped together for added visibility and convenience. | TOTE-468 |
AC |
relatedVariantDisplayName | This is the display label used for the variant's button. | TOTE-154 |
| PRODUCT SHIPPING DATA | Previous ↑ | Next ↓ | ||
AD |
Ship1 Qty (int) | The number of individual items contained within the first shipping carton. The "(int)" stands for integer, meaning this must be a whole number |
50 |
AE |
Ship1 Length (in) | The measurement of the longest side of the shipping carton, measured in inches. | 24 |
AF |
Ship1 Width (in) | The measurement of the shorter horizontal side of the shipping carton, measured in inches. | 18 |
AG |
Ship1 Height (in) | The vertical measurement of the shipping carton from top to bottom, measured in inches. | 12 |
AH |
Ship1 Weight (lbs) | The total weight of one fully packed shipping carton, measured in pounds. | 22.5 |
The above Shipping Data series repeats for additional shipping data as needed through column AR | |||
| PRICING DATA | Previous ↑ | Next ↓ | ||
AI |
Quantity 1 | Quantity refers to the specific number of units a customer must order to receive a certain price point | 50 |
Quantities repeat through column BD | |||
BE |
Price 1 | The cost assigned to a single item within a specific quantity tier | 15.00 |
Price repeats through column BN | |||
BO |
Margin Code 1 | A system identifier that sets the percentage spread between a product’s suggested retail price and the distributor’s net cost. Also known as "discount codes". |
A |
Margin Codes continue through column BX | |||
|
LOCATION & DECORATION DATA (Setup and Charge Data) |
Previous ↑ | Next ↓ |
||
BY |
Imprint 1 Method | The first technique used to apply a logo. | Embroidery |
BZ |
Imprint 1 Description | Detailed description of this imprint method | This method provides a durable, professional, and "raised" 3D texture that is ideal for headwear, outerwear, and polos. |
CA |
Imprint 1 Colors | The colors available for this imprint method separated by a pipe (e.g. "|") | Red|Blue|Black |
CB |
Imprint 1 Colors Included | The number of imprint colors included in the base price | 1 |
CC |
Imprint 1 Height (in) | The vertical measurement of the allowed decoration area, expressed in inches. | 2 |
CD |
Imprint 1 Width (in) | The horizontal measurement of the allowed decoration area, expressed in inches. | 4 |
CE |
Imprint 1 Diameter (in) | The circular measurement for imprints on round objects (e.g., the bottom of a mug or the top of a coaster). | 3 |
CF |
Imprint 1 Location | The specific placement of the decoration on the product. | Centered on Front |
CG |
Imprint 1 Setup Charge | The fixed, one-time cost required to prepare the machinery for this specific imprint (e.g., creating a screen or digitizing a file). | 5.00 |
CH |
Imprint 1 Setup Charge Code | The Margin Code that identifies the discount or markup percentage applied to the setup fee. This dictates the spread between the distributor's cost and the suggested retail price. | C |
CI |
Imprint 1 Setup Charge Uom (default Per Order) | Stands for Unit of Measure. This defaults to "Per Order," meaning the setup fee is charged once regardless of quantity. | Per Order |
CJ |
Imprint 1 Quantity 1 | The first tier of pricing for this specific imprint method. | 50 |
Imprint 1's Quantities continue through column CS | |||
CT |
Imprint 1 Run Charge 1 | The additional cost charged per unit to apply the first imprint method to a product. | 1 |
Imprint 1's run Charges continue through column DC | |||
DD |
Imprint 1 Run Charge 1 Code | The Margin Code (or Discount Code) assigned to the run charge. | C |
Imprint 1 Run Charge 1's Codes continue through column DM | |||
The above Imprint series repeats for additional imprints as needed through column FB | |||