Product import column definitions
| Field Name | Required app/setting | Description | Guidance/Instructions | Example Values |
|---|---|---|---|---|
| Item ID | N/A | Unique identifier for each product in the system | If you are creating a new product, leave this field blank. If you are updating an existing product, you must not change the number in this field. This is not the same as your product’s SKU code. |
N/A (System-generated) |
| Item Name | N/A | Name of the product | Enter the name of the product here. HTML is not allowed. |
Leather Wallet |
| Item Description | N/A | Product description | Enter the description of the product here. You can use either HTML or plain text. Don’t allow the description to take up more than one row on the spreadsheet. |
A stylish and durable leather wallet. |
| Item Description 2...5 | ||||
| Image URL/File Name 1... | N/A | Image URLs for product images | Use these fields to add images for the product. Only .jpg, .jpeg, .png, and .gif files are accepted. .WebP images cannot be imported. if the image files are on your device's hard drive You don’t have to use all 5 fields. |
http://www.website.com/images/wallet.jpg |
| ALT Tag 1... | N/A | ALT tags for the corresponding images | Specify the text for an ALT tag for the corresponding image. The ALT tag is used when the image doesn’t display on the page or by screen reading software. |
Brown leather wallet |
| Item Video | Product video URL | To enter a video for the product, you will need to have uploaded the video to a video-sharing website (like YouTube or Vimeo). Then you can obtain the for the video and place it in this field. | <iframe...> |
|
| Category 1... | N/A | Product category | Enter the exact name of the category you want to assign to the product. For parent & subcategories, enter the final category only. Use if you have multiple categories of the same name - if using IDs all categories in all rows must be specified by ID |
Accessories > Wallets |
| Brand | Brand name | Enter the exact name of the brand you want to assign to the product. | Handmade Co. |
|
| Option 1... | The applicable filters for each filter group | Enter the values for each filter for each filter group. Enter multiple filters separated with a comma. Multiple columns will be displayed for each configured filter group |
Brown |
|
| Price | N/A | Regular selling price of the product | Enter the normal selling price for the product. Enter the cheapest price if the product has variations. |
29.99 |
| Sale Price | N/A | Discounted price of the product | Enter the sale price if applicable. | 19.99 |
| RRP | N/A | Recommended retail price | Enter the RRP for the product. | 34.99 |
| SKU | N/A | Stock keeping unit | Enter the SKU for stock management. The system will track stock and show out of stock message when quantity is zero. |
WLT12345 |
| Opening Stock | N/A | Initial stock level | Enter the quantity of stock. Ignored if SKU is not provided. |
50 |
| Purchasable When Out Of Stock | Purchase setting for out-of-stock items | Enter Yes or 1 to allow purchasing when the product is out of stock.Enter No or 0 to disallow.Use this if you want to enable back orders. |
Yes |
|
| Out Of Stock Quantity Limit | Limit for purchasing out-of-stock items | Enter the maximum number of out-of-stock items that can be purchased. Leave blank if there is no limit. Useful to control overselling. |
5 |
|
| Weight | N/A | Product weight | Enter the weight in kg or grams. Use numeric values only. | 0.2 |
| Delivery Price | N/A | Specific delivery charge | Enter the delivery price. Enter Free for free delivery. Enter remove to delete a previous delivery price.When using shipping on basket configuration, enter the delivery price, e.g. enter 1.00 (for £1.00) or Free for free delivery. |
Free |
| Delivery Price (Per Zone) | Delivery price for specific zones | When configuring specific delivery prices for multiple zones, enter all of the delivery prices into this single column in the format Country: Price, Country: Price.e.g. United Kingdom: Free, United States: 10.00, France: 3.50.You must enter the names of the countries correctly, in accordance with the ShopWired country naming convention. |
United Kingdom: Free |
|
| Single Delivery Cost? | N/A | Whether the delivery cost applies per item | Enter Yes or 1 to not charge multiple times. Enter No or 0 to charge multiple times.This applies when using shipping on basket or shipping on checkout configuration. |
No |
| Delivery Address Not Required | N/A | If delivery address is not needed | Enter Yes or 1 if no address is required. Leave blank or enter No or 0 if address is required. |
No |
| Cost Price | Cost price of the product | Enter the cost price if using the gross profit report app. | 10.00 |
|
| VAT Exclusive | Whether the product is exempt from VAT | Enter Yes or 1 if VAT exempt. Leave blank or enter No for standard VAT rate. |
No |
|
| VAT Relief | If product is eligible for VAT relief | Enter Yes or 1 if eligible. Leave blank if not eligible. |
No |
|
| Custom VAT Rate | Custom VAT rate for the product | Enter the VAT rate in numeric form only. Do not include % symbol. |
20 |
|
| Custom Search Keywords | Any specific keywords for the product | Enter keywords or keyphrases separated with a comma | Brown leather wallet |
|
| URL | N/A | Custom URL for the product | Enter the desired URL string. Only letters, numbers, hyphen -, and underscore _ allowed. |
leather-wallet |
| Meta Title | Custom meta title | Enter a meta title up to 70 characters. | Stylish Leather Wallet |
|
| Meta Keywords | Meta keywords for SEO | Enter up to 6 keywords separated by commas. Do not exceed 70 characters. | wallet, leather, accessory |
|
| Meta Description | Meta description for SEO | Enter a description up to 160 characters. | A high-quality leather wallet, perfect for everyday use. |
|
| Related Products | N/A | IDs of related products | Enter multiple IDs separated with a comma | 23456, 23457, 23458 |
| Optional Extra Name 1... | N/A | Name of the optional extra | Enter a name for the product extra. This will be displayed on your website. |
Gift Wrapping |
| Optional Extra Price 1... | N/A | Price for the optional extra | Enter the price specifically for the extra (added onto the product price). If the extra is free, leave the price setting empty. |
4.95 |
| Optional Extra Cost Price 1... | N/A | Cost price for the optional extra | Enter the cost price for the optional extra if tracking profits. | 2.00 |
| Optional Extra SKU 1... | N/A | SKU for the optional extra | Enter the SKU for the optional extra if linking it to a product on your ShopWired account. | GW123 |
| Archived | N/A | If the product is archived | Enter Yes or 1 to archive the product so it doesn’t display on your website. |
No |
| Reward Points Earned With Purchase | The number of reward points that the customer will earn when purchasing the product | Enter numbers only | 30 | |
| Warehouse Notes | Internal notes for the warehouse | Enter notes for internal warehouse use. Warehouse notes are not displayed on your website or to your customers. This is a legacy feature and has been replaced by custom fields. |
Handle with care |
|
| Global Trade Item Number (GTIN) | N/A | Unique product identifier | Enter the GTIN assigned to the product by the manufacturer. Leave blank if not applicable. GTINs include UPC, EAN, and ISBN numbers. |
9780306406157 |
| Manufacturer Part Number (MPN) | N/A | Manufacturer's part number | Enter the MPN assigned by the manufacturer. Leave blank if not applicable. Used for identifying specific products made by a manufacturer. |
WLT789 |
| Is this Product a 2 for 1 Product? | Eligibility for 2 for 1 offer | Enter Yes or 1 if the product is eligible for a 2 for 1 offer.Leave blank if not eligible. The cheapest product is free. |
No |
|
| Is this Product a 3 for 2 Product? | Eligibility for 3 for 2 offer | Enter Yes or 1 if the product is eligible for a 3 for 2 offer.Leave blank if not eligible. The cheapest product is free. |
No |
|
| Is the Product New? | N/A | New product indicator | Enter Yes or 1 if the product is new.Leave blank if not applicable. Helps in categorising and displaying the product as new to customers. |
Yes |
| Trade Discount Exclusion | Enter Yes if the product is excluded from |
No |
||
| Product Choice... | N/A | Refer to the guidance on importing product choices | ||
| File Uploads | Number of file uploads allowed | Enter the number of file upload fields allowed for the product. This allows customers to upload files when adding the product to their basket. Use whole numbers only. |
2 |
|
| Sort Order | N/A | Order in which the product appears | Enter a numeric value to determine the product's sort order. | 1 |
| Variant ... | N/A | Refer to the guidance on importing variations | ||
| Pre-order | Indicates if the product is a pre-order | Enter Yes or 1 if the product is a pre-order product.Leave blank if not applicable. Pre-order products are not available for immediate dispatch and will ship on the specified date. |
No |
|
| Pre-order Shipping Date | Expected shipping date for pre-order products | Enter the date you expect to be able to ship the product to the customer. Format the date as DD/MM/YYYY.This date informs customers when the product will be dispatched. |
31/03/2025 |
|
| Pre-order Release Date | Release date/time for the pre-order product | Enter the date and time when the product will be available for purchase. Format the date as DD/MM/YYYY HH:MM.Before this date, the product won't be displayed in search results or category pages. |
01/04/2025 10:00 |
|
| Subscription Interval | Subscription billing interval | Enter the billing interval for the subscription product. Available values: daily, weekly, fortnightly, monthly, 2 monthly, 3 monthly, 6 monthly, yearly, 30 days, 60 days, 90 days.Defines how often the customer is billed for the subscription. |
monthly |
|
| Subscription Discount From Normal Price | Discount applied to subscription | Enter the discount percentage off the product's normal price. Use a numeric value without the % symbol.This discount applies to each interval of the subscription. |
10 |
|
| Subscription Fixed Intervals | Number of fixed billing intervals | Enter the number of intervals for the subscription, if it has a fixed duration. Leave blank for ongoing subscriptions. Defines the number of billing cycles after which the subscription is automatically cancelled. |
6 |
|
| Google Category | Product category for Google Shopping | Enter the Google product category ID. Refer to Google's category list for ID values. This helps in placing your product in the correct category on Google Shopping. |
543682 |
|
| Google Condition | Condition of the product | Enter the condition of the product. Available values: New, Used, Refurbished.You must inform Google of the condition of used or refurbished products to avoid listing rejection. |
New |
|
| Google Is Bundle | Indicates if the product is a bundle | Enter Yes or 1 if the product is a bundle.Leave blank if not applicable. This aligns with Google’s is_bundle attribute requirements. |
No |
|
| Google No Identifier Exists | Indicates if the product has no unique identifier | Enter Yes or 1 if the product has no GTIN or MPN.Leave blank if not applicable. Use this if the product does not have a GTIN, MPN, or brand. |
No |
|
| Google Age Group | Age group for the product | Enter the appropriate age group. Available values: newborn, infant, toddler, kids, adult.This is used for categorising products based on age appropriateness. |
adult |
|
| Google Gender | Gender specification for the product | Enter the appropriate gender. Available values: male, female, unisex.This helps target your product to the correct audience. |
unisex |
|
| Google Material | Material of the product | Enter the material of the product. Consult Google’s guidelines for acceptable values. Provides details about the product's composition. |
Leather |
|
| Google Pattern | Pattern of the product | Enter the pattern of the product. Consult Google’s guidelines for acceptable values. Describes the visual design on the product. |
Solid |
|
| Google Size Type | Size type for the product | Enter the size type of the product. Available values: regular, petite, plus, big_and_tall, maternity.Helps in specifying the size category for apparel. |
regular |
|
| Google Colour | Colour of the product | Enter the colour of the product. Consult Google’s guidelines for acceptable values. Describes the product's primary colour. |
Brown |
|
| Google Size | Size of the product | Enter the size of the product. Consult Google’s guidelines for acceptable values. Defines the dimensions or size category. |
One Size |
|
| Google Ships From Country | Shipping origin country | Enter the ISO-3166-2 Alpha 2 country code. e.g. GB for the United Kingdom.Indicates the country from which the product ships. |
GB |
|
| eBay Category | The primary eBay category ID for the product | Enter the specific eBay category ID. You can only select a leaf category (i.e., a category that does not have subcategories). |
12345 |
|
| eBay Secondary Category | The secondary eBay category ID for the product | Enter the secondary eBay category ID. Optional field to assign an additional category for broader visibility. |
67890 |
|
| eBay Own Product Category | Your own curated eBay category ID | Enter the ID from your own eBay store category list. Used for navigation within your eBay store. |
11223 |
|
| eBay Secondary Own Product Category | The secondary curated eBay category ID | Enter the secondary curated category ID from your eBay store. Used for navigation within your eBay store. |
44556 |
|
| eBay Condition | The condition of the product as recognised by eBay | Enter the condition ID provided by eBay. List of available conditions can be found on eBay's website. This is a required field. |
1000 |
|
| eBay Service 1...9 | Shipping services for the product | Enter the ID of the shipping service. These IDs are set on the eBay settings page. You can configure up to 9 services. |
1 |
|
| eBay Global Shipping | Eligibility for eBay's Global Shipping Programme | Enter Yes to mark the product as eligible.Expands market availability for international buyers. |
Yes |
|
| eBay Item ID | The eBay listing ID | Leave blank when creating new products. It will contain the eBay listing ID when exporting linked products. |
1234567890 |
|
| eBay Listing Title | A separate title for the eBay listing | Enter a custom title for the eBay listing. Optional field if different from the product title on ShopWired. |
Classic Leather Wallet |
|
| eBay Shipping Profile | eBay shipping profile ID | Enter the ID of the shipping profile from your eBay account. Use if you have enabled eBay profiles in ShopWired. |
234567 |
|
| eBay Payment Profile | eBay payment profile ID | Enter the ID of the payment profile from your eBay account. Use if you have enabled eBay profiles in ShopWired. |
345678 |
|
| eBay Return Profile | eBay return profile ID | Enter the ID of the return profile from your eBay account. Use if you have enabled eBay profiles in ShopWired. |
456789 |
|
| Custom Field - rm_hs_tariff_code | HS Tariff Code used for international shipping. Required for customs declarations when shipping outside of the UK. | Yes | 123456 |
|
| Custom Field - rm_customs_description | Detailed description of the product for customs purposes. | Yes | Men's Leather Wallet |
|
| Custom Field - rm_origin_country | Country of origin of the product. Required for customs declarations. | Yes | United Kingdom |
|
| Custom Field - ss_customs_origin_country | Used to specify the country of origin for a product when exporting orders through the ShipStation app. This is necessary for international shipping to comply with customs regulations. | Yes | United Kingdom |
|
| Customisation Field Label | Label for customisation field | Enter the label for the customisation field. This will be displayed to the customer on the product page. Useful for gathering custom input like "Name for Engraving." |
Personal Message |
|
| Customisation Field Type | Type of customisation field | Enter the type of customisation field. Supported types include text, textarea, select, etc.This defines the kind of input the customer can provide. |
text |
|
| Customisation Field Max Length | Maximum length for customisation input | Enter the maximum number of characters allowed for the input. Only applies to text or textarea fields.Helps limit the length of custom messages. |
100 |
|
| Bundle | Indicates if the product is a bundle | Enter Yes or 1 if the product is a bundle/package product.Leave blank if not applicable. Bundles allow you to group multiple products together as a single offering. |
No |
|
| Bundle Products | Constituent products of the bundle | Enter the SKU code and quantity of each product in the bundle. Separate SKUs and quantities with a comma, and use x to indicate quantity.e.g., SKU123 x 1, SKU124 x 2.This defines which products are included in the bundle and their quantities. |
WLT123 x 1 |
|
| Bundle Title | Title for the bundle | Enter a title for the bundle that will be displayed when the bundle is shown on a constituent product page. Leave blank to use the default bundle title. |
Special Offer |
|
| Bundle Image URL | Image for the bundle | Enter the URL for an image representing the bundle. This image will be displayed when the bundle is shown on a constituent product page. Use the full URL including http:// or https://. |
http://s3.shopwired.co.uk/1016/bundle_image.png |
|
| HS Tariff Code | N/A | Harmonised System (HS) Tariff Code | Enter the HS Tariff Code for the product. This code is used for international shipping and customs to identify the product type. Refer to the official HS code list to find the correct code for your product. |
420231 |
| Digital Downloads | Files for digital products | Enter either the digital file ID or the URL for externally hosted files. Separate multiple files with a comma. To use files stored in your ShopWired account, enter their unique IDs. For externally hosted files, provide the direct URL to the file. |
6789, https://s3-eu-west-1.amazonaws.com/mystorefiles/file.pdf |
|
| Minimum Order Quantity | Minimum quantity required for purchase | Enter the minimum quantity a customer must purchase for this product. Leave blank if no minimum is required. |
1 |
|
| Maximum Order Quantity | Maximum quantity allowed for purchase | Enter the maximum quantity a customer can purchase for this product. Leave blank if there is no maximum limit. |
5 |
