- Complete CSV Import/Export template.
- Email to web@advantus.com for upload.
Below you will find how to fill in the spreadsheet. If you are unsure of which information to enter in a certain field, please refer to the glossary index below for clarification.
See definitions for each category header within the .csv file to ensure a successful upload.
Handle:
This is seen at the end web address title of the product. You can specify unique product names letters, dashes, or numbers.
PLEASE NOTE: Spaces, accents, periods, and certain other characters are prohibited, stick to the previously mentioned inputs.
Example:
You enter “3-day-stretch-backpack-nwu-type-iii” in that field and the web address will be: https://mercurytacticalgear.com/products/3-day-stretch-backpack-nwu-type-iii
Title:
Simply put this is the Title of the product. Whatever you put in the Title cell will become the name of the product.
Body (HTML): This is the main product description area. You can use plain text or HTML within this area.
Vendor:
Vendor Name for the product shown. Who makes/creates/sells the product (more than likely would just be the Brand’s Name). Is required, but can be left blank and added in once uploaded if need be.
Type:
This would be the product type. If you are uploading a backpack, you would put backpack and it will set the type as such.
This is not required at upload but does help with SEO and overall search options. Shopify has presets “Types” to choose from once the product is uploaded. However, if the type is not in the presets, Shopify will override it with whatever you enter.
Tags:
These would be attributes or adjectives for the product. Each tag must be separated by a comma.
Example: Tags are vital for setting collections up within the store. After uploading the backpack we previously mentioned, you could tag it as such: Black, water-resistant, hydration-ready, backpack.
If you need more clarification on tags: https://help.shopify.com/en/manual/shopify-admin/productivity-tools/using-tags
Published:
This section relates to if you wish to have your product listed on the storefront (your shop). This is a required field and you can only use one of the two options.
TRUE: Product is published
FALSE: Product is hidden
Option1 Name:
Specify a product option name (Could be but is not limited to: Color, Size, Material, etc). This section is MAINLY used for when products have variants, when they come in different colors, different sizes, etc.
Option1 Value:
This is where would you list the attribute connected with the Option1 Name, if more than one, separate by comma(s).
Example:
You entered “Color” for Option1 Name – For Option1 Value, you could then set the colors the product is available in as such: “Black, White, Red, Green, Blue”. Once published, the product will then have the variants listed on the product page as an option to be selected.
Option2 Name: See Option1
Option2 Value: See Option1
Option3 Name: See Option1
Option3 Value: See Option1
Variant SKU:
SKU of product
Variant Grams:
This is the product’s weight in grams. Please note it MUST be in g/grams and can ONLY be numbers, no other characters. So if the product weighs 1.234 kg/kilograms you should enter it as 1234 g/grams.
Variant Inventory Tracker:
For internal tracking purposes, as of now not needed. Can be left blank.
Variant Inventory Qty:
Available inventory to be sold. Should be a number.
Variant Inventory Policy:
There are 2 options for this section that has to deal with the inventory reaching 0.
– Deny: Product can NOT be purchased after zeroing out.
– Continue: Product CAN be sold when inventory runs out.
Variant Fulfillment Service:
Who fulfills the order (manual, Amazon, etc). Can be left blank.
Variant Price:
Price of the product. Do not use currency symbols. $49.99 should be entered as 49.99
Variant Compare at Price:
Enter the ‘compare at price’ here. Again, no currency symbols.
Variant requires Shipping:
IF shipping is required, which 99.9% of the time it will be, here is where you would put that value. You can only use two values:
TRUE – Requires Shipping
FALSE (can also be left blank if False) – Items that do NOT require shipping. Example: Downloadable content
Variant Taxable:
Specify whether taxes are applied to a variant or not. Values can only be:
TRUE if taxed
FALSE if not taxed.
Variant Barcode:
If you have a product’s barcode #, ISBN, or UPC enter that here.
Image Src:
Use links of images to be downloaded and uploaded to the product page. If you have the product pages uploaded elsewhere, link them and Shopify will download them and upload them to the page for you.
Honestly, It may be easier to upload the images directly to Shopify but would have to be done within the backend of the store.
Image Position:
Set the order of your photos by choosing 1, 2, 3, etc. 1 being the main default image, then going in the corresponding order.
Image Alt Text:
Alt text for each image being uploaded. Used for SEO and assistive technology (hearing or sight impaired, etc). You can use up to 512 characters to describe an item, however, the optimal length is around 125. Can be left blank.
Gift Card:
Can a product be purchased with a Gift Card (if a Gift Card has been set up prior). Only two values are allowed here
TRUE – can be used to buy the product
FALSE – can’t be used to buy the product
SEO Title:
Search Engine listing preview/Page title
SEO Description:
SEO Description is situated in the Mate Description field on the product details page, you can use more than 320 letters and numbers. If left blank the original product description is used on import.
Variant Image:
If you have multiple product images, link those here. Please see Image Src and Image position.
Variant Weight Unit:
Use the following weight values: g (grams), kg (kilograms), lb (pounds), and oz (ounces). If no weight value is given, Shopify defaults to kilograms/kg.
Variant Tax Code:
This column is available in Shopify Plus only if it is integrated with Avalara AvaTax. Don’t import a CVS file with this column field in with data into a store that isn’t connected to Avalara
Cost Per Item:
Our cost of items or variants. Do not use any currency symbols. If the product has variants, separate the costs by commas.
Status:
This can only be 1 of 3 options.
Active: Available on the storefront
Draft: Uncompleted product not ready to be published.
Archived: No longer available in the storefront.