Import fields | Tradevine

This page details the import fields when you import your product records from a file. The steps to import your products are covered on another page.

On this page, you can view the info, which is specific to:

General fields
Pricing fields
Inventory fields
BoM fields
Supplier fields
Trade Me specific fields
Shopify webstore fields.

We don’t intend to detail every field, just the ones where we think you might need more clues. This should help you format the data in a way that we are expecting so that we can upload your data.

Very few of the fields are mandatory. When importing, you do not have to hook up every import field. Generally blank data is either defaulted or ignored.

You can download a blank import template file to use to import your products. Once you have downloaded this file, feel free to rename it with any name, but you must save it as a csv type file, not an xls or xlsx type file.

You can also download an example file with example data. Do not use this file to import with.

You can also view a quick heads up on the data types. This is useful for evaluating any import errors.

General fields

Product Code: Is a mandatory field. 50 characters max. Each code should be unique, otherwise we will update the product with the details from the last record we encounter. If your code exceeds 50 characters, then an auto-generated code will be created instead.
Replacement Code: Is an optional field. 50 characters max. This field can be used to replace your existing product codes.; Be very aware that if you have imported new replacement codes, you should not re-run your import until you have adjusted your import file and swapped your old product codes for your new replacement codes.
Alternate Code: Is an optional field. 50 characters max. This field allows you to specify a secondary product code.
Manufacturer Code: Is an optional field. 70 characters max. This field allows you to specify a manufacturer’s code for each product.
Brand: Is an optional field. 70 characters max. This field allows you to specify a brand for each product.
Product Name: Can be up to 80 characters. This is the name of the product.
Product Description: Can be up to 2048 characters. Each paragraph may count as one character, since paragraphs are often created with a hidden character.; NB: if there is any HTML type formatting in this fields data, then the HTML will be stripped out when you import your products.
Photo Identifier: Use this field if you are importing your photos by filename or from a website.; If you are uploading your photos from your computer using filenames, then you should upload the photos first via the Photos screen before running your import.; If you are uploading from a website then you can enter the URL path in either HTTP or FTP format. Eg, http://www.uvxyz.com/uploads/54321.jpg or ftp://username:password@ftp.somesite.com/image/image.jpg; If you have multiple photos, then separate your filenames or file paths with semi-colons. The leftmost filename will be the main photo. Photos will be uploaded in the sequence order that you list them in.; Photos referenced here, also need to be referenced in the Trade Me Rule Photo Identifier and the Shopify Photo Identifiers fields, so they can be used in Trade Me and Shopify.
Labels: Use this field to assign labels to your products.; Separate multiple labels with comma’s. Labels which include a comma should be enclosed in double quotes.; Eg, Novelty Item, “Asia, Europe”, Fragile
Manual Order Approval: Use this field to set the products which need to be manually approved whenever they appear on a sales order. No or blank is the default, otherwise set this to Yes.
Height: The product’s height.
Width: The width of the product.
Length: The length, depth or span of the product.
Weight: The weight of the product.
Is Archived: Set this to yes if you want to archive the product.
Internal Notes: This field allows you to insert up to 4000 characters for private product notes, that the buyer/supplier will never see.
External Notes: This field allows you to insert up to 4000 characters for public product notes, that the buyer/supplier will see.
Exclude From Order Combining: Set this if the product should be excluded from combining sales orders.
BoM Weight Calculated From Components: Set this if you want the weight of the BoM kit to be auto-calculated when the components change.

Pricing fields

Cost Price: The cost price should exclude GST even if your organisation is not registered for GST.; This field is mandatory unless Inventory Enabled is false. You can import a value of 0.00. When Inventory Enabled is true, the Cost Price is locked in and not editable once the import completes.
Tax Code: We are looking for exact matches. For New Zealand and Australia, we are looking for the following tax codes: GST, Exempt, None, Zero. They are not case sensitive, so we will also take either gst or GST or Gst etc.; New Zealand organisations should always set the product’s tax rate to GST, regardless of your own tax status. The only exceptions are the zero rated supplies recognised by IRD.
Sell Price (ex. tax): This is the sell price excluding any taxes.
Sell Price (inc. tax): This field is validated against the Sell Price (ex. tax) in conjunction with the Tax Code field. Eg, if you have a Tax Code of GST (NZ at 15%, Australia at 10%) then we check to ensure the Sell Price (inc. tax) includes the 15% etc. If the Tax Code has a zero percentage (Zero, None, Exempt) then we validate the import to ensure that the inclusive price is the same as the exclusive price.

Inventory fields

Unit of Measure: Determines how you sell the quantities of your product. Eg, each, box, carton.
Barcode / GTIN: The product’s barcode or unique GTIN identifier. It is optional and can be up to 100 characters max.
Inventory Enabled: This field defines whether you want to track the inventory quantities of the product.
Warehouse Code: Optional. If not specified then this will be your default primary warehouse. Otherwise, if you have multiple warehouses, this should be the code of the warehouse to add this product’s stock to.
Warehouse Stock: This is the current stock quantity for the product. The physical on the shelf quantity. If you have multiple warehouses then this is the stock quantity for the warehouse defined in the Warehouse Code field. If the warehouse code is not defined, then this will be your default primary warehouse.
Minimum Stock Quantity: This is the minimum stock level quantity for the product.
Auto Archive When No Stock: The product will be automatically archived when the stock levels next hit zero.
GL Account (Sales): This field is required if you are integrated with Xero and Inventory Enabled is set to false/no. We are looking for only your Xero account code. Eg if your account name is 610 – Accounts Receivable, only the code component 610 will fly.; Where we display your Xero account mappings as a code and description, for the import we are only looking for the code, like for example if we display 123-Sales | Sales Revenue, then we are expecting 123-Sales . This will be all the text to the left of the pipe character.
GL Account (Purchases): This field is required if you are integrated with Xero and Inventory Enabled is set to false/no. We are looking for only your Xero account code. Eg if your account name is 800 – Accounts Payable, only the code component 800 will fly.; Where we display your Xero account mappings as a code and description, for the import we are only looking for the code, like for example if we display 567-Purchases | Purchased Assets, then we are expecting 567-Purchases. This will be all the text to the left of the pipe character.

BoM fields

Importing your BoM products should be done as a separate import. To create an import template file, navigate to your main Products screen and select at least one record from the list of products. Then opt for Export > BoM. Complete the file and then import the file.

BoM Component Product Code: This is the product code for the component product that belongs to a kit type BoM (Bill of Materials) product.; If this product is not part of a BoM product, then leave this field blank.
BoM Component Quantity: If you specified a product code in the BoM Component Product Code field then you will need to specify how many of the product code will be required to contribute to making up the BoM product.; If this product is not part of a BoM product, then leave this field blank.
BoM Remove Component: Set this to Yes, if you need to remove the product from your BoM product.; If this product is not part of a BoM product, then leave this field blank.

Supplier fields

Importing your preferred suppliers for your products should be done as a separate import. To create an import template file, navigate to your Product Suppliers screen and export at least one record from the list. Complete the file for each product and supplier you want to import and then import the file.

Supplier Code: This is only for suppliers who already exist in your Tradevine organisation. You can’t use this field to create new suppliers for products. The other supplier fields in the import file are lifeless without this field. You can have more than one supplier for each product, but you will have to duplicate the row for the product and then just change the supplier data in a new row. This is a mandatory field.
Supplier Product Code: This is invariably your supplier’s product code. This is a mandatory field.
Supplier Price: This is the purchase price from the supplier. This is a mandatory field.
Supplier Price Includes Tax: Set this to true/yes if the suppliers price includes tax.
Supplier Default Order Multiple: This is effectively the batch re-order quantity. This value is used in conjunction with your minimum stock quantity and auto-purchase re-ordering.; So for example, if you have to re-order in batch quantities like 10 at a time, but you are out of stock by 23, then the minimum auto-reorder quantity would be 30. Your Default Order Multiple quantity would be 10.; This is a mandatory field.
Supplier Is Preferred: If you only have a solitary supplier then this supplier would be your preferred supplier by default. Otherwise, if you have multiple suppliers just tag the preferred supplier with either yes or true.
Remove Supplier Product: Set this field to true or yes if you now want to delete a supplier from a product.

Trade Me fields

Account Name: The is mandatory if you have more than one Trade Me account configured.; We are looking for the Trade Me username.; If you have multiple Trade Me accounts, then you will need to duplicate the products in the import file and include the Account Name against each product line.
Rule Name: The name of your listing rule for the product is not mandatory and will be defaulted to Rule 1 if you haven’t provided a rule name. Should you do any further re-importing, it would be advisable to provide the rule name, so that we know which rule to update, otherwise, we may end up creating additional rules.; If you rename your rule within Tradevine, then remember to update your import file with the latest rule name.
Rule Priority: The listing rule priority is optional. If you haven’t provided a priority, then it will be defaulted to Medium.; The expected values are either High, Medium or Low.
Populate From Listing ID: The ID is used to populate the listing rule details for the product from the settings used on the listing itself. It is used mainly for importing products from other systems.
Title: The listing title is mandatory. It can be up to 80 characters long.
Subtitle: An optional subtitle for the listing. It can be up to 50 characters long.
Description: This is the main listing description.; It can be up to 2048 characters. Each paragraph may count as one character, since paragraphs are often created with a hidden character. Be aware that the listing footer text also contributes towards the 2048 character limit.; NB: if there is any HTML type formatting in this fields data, then the HTML will be stripped out when you import your products.
Is Listing Footer Enabled: Defines whether you want to append a common set of footer text to the bottom of the listing description.; This will default to no, unless you specify Yes or True.
Is New: Is the product brand new and therefore not secondhand?; This will default to no, unless you specify Yes or True.
Category: Trade Me category references must use Trade Me’s reference numbers, not the text wording. Eg, either 1234-1234-5678- or just 5678 (that one wasn’t real, we just wanted to show you the expected format). Any values less than 4 digits will be converted when importing with leading zero’s. Eg, 21 will be converted to 0021. We recommend the 4 digit only format, since this provides more future proofing for when Trade Me change their category structure.
Category Options: These are the attributes that you sometimes see with some types of listings. Eg, Computers can have drive types, CPU speeds, hard drive sizes, memory size etc etc. An example of a DVD listing would be: Condition=Asnew;NZClassification=2;NumberOfDiscs=3;DvdRegion=4;; Note that each piece of data is separated by a semi-colon. Within that, each piece of data is separated again into a Name and a Value. So an example of the syntax would be: Name1=Value1;Name2=Value2;Name3=Value3 and so on.; The name of each attribute is explicit to Trade Me. Sometimes the data on the right hand side of the equal sign is also explicit to Trade Me. We don’t have a full list of these attributes and their expected values. A manual way to get these (providing you are integrated in our system with Trade Me) would be to select a category via the Trade Me tab of a product and then note the captions and values within the dropdowns etc.; The attributes names can be either the technical name or the display name, but must be an exact match.; You don’t have to complete every attribute or put them in an exact order. Any missing attributes may need to be updated manually in the product by yourself.
Category Legal Notice Read: Some listing categories require you to confirm you accept the legal notice. Only true or blank values will pass the import. False values will fail the import.
Is Classified: Some categories can be either an auction or a classified. For categories that can be either you should set this field to either yes or no. Auction is the default if this field is left blank.
Is Sold In Multiple Quantities: If you want to sell with quantities greater than zero, then set this to True or Yes.
Sell Multiple Quantity: The maximum quantity to buy.
Is Shipping Per Item: Set this to Yes, if the cost of shipping the goods is based on each item purchased. Otherwise, this will just be a single cost regardless of how many items were bought.; This is relevant if you have set your Shipping Options to Fixed shipping costs and specified the costs in the Shipping Details column.
Start Price: This sets the Start price for each product when you list.
Reserve Price: This sets the Reserve price for each product when you list. It is optional. If this is blank then it will be set to the same as your Start price.
Buy Now Price: This sets the Buy Now price for each product when you list. It is optional.; Be aware that when listing with a Buy Now, but not a reserve, as soon as the first bid is made, the Buy Now button will disappear in Trade Me.
Clearance Item: If you are configured as a premium Stores Extra in Trade Me and have been authorised to do clearance items, then you can flag your clearance products in Trade Me, by setting this to true.
Was Price: Only available if you are authorised by Trade Me to do clearance items.; Only available when Sell Multiple Quantity is set to true.; Was price is the price the item was previously selling for. This should be higher than the Buy Now price.
Price Promotion Code: Only available if you are authorised by Trade Me to do clearance items.; Only available when Sell Multiple Quantity is set to true because the price promotion discount is applied to the Buy Now price.; The code should already exist in the Price Promotions table in your Trade Me default settings.
DVD Catalogue ID: This is an ID number from Trade Me’s DVD Catalogue that is used to auto complete DVD listing content and details. It is optional.
Auto-listing Enabled: Set this to true/yes if you want your product to auto-list.; Be aware that the global auto-listing flag needs to be set via the Settings > Trade Me Settings screen for auto-listing to initiate.
Authenticated Bidders Only: Set this to true or yes, if you only want authenticated members to bid on your listings.
Trade Me Rule Photo Identifiers: Use this to reference the filenames or the URLs of the photos to display in Trade Me. Leaving this blank will ensure there are no photos on your Trade Me channel. Photos referenced on your product, but not here, will be available on your Trade Me channel, but not selected and not visible in Trade Me (unless this field was not mapped during the import, in which case the photos defined on the product’s photo identifier will be used and selected for Trade Me). Photos must be referenced in the Product Photo Identifier field before they can be referenced here.; Multiple filenames and file paths should be separated with a semi-colon. The leftmost filename will be the main Trade Me photo. Photos will be uploaded and displayed in the sequence order that you list them in. Photos that have been stated on the product, but not here, will be available but not selected.; If you are uploading from a website then you can enter the URL path in either HTTP or FTP format. Eg, http://www.uvxyz.com/uploads/54321.jpg or ftp://username:password@ftp.somesite.com/image/image.jpg
YouTube Video Key: If you are a Top Seller or a Store then you have the option to add a YouTube video to your listing. Simply insert the video key code and NOT the full URL. Eg. v=6rPHrjJ1Hyo or 6rPHrjJ1Hyo
Displayed Bold: Set this to true/yes if you want your listings to be displayed with a bold title to get people’s attention. There is a small charge from Trade Me for this feature.
Gallery: Set this to true/yes if you want to include a main photo with each listing. Gallery can be a tickle cheaper than Gallery Plus in some circumstances. Gallery gets charged for every listing.
Gallery Plus: Set this to true/yes if you want your product’s to utilise Gallery Plus. Gallery Plus allows you to list up to 3 times, but only pay once for the cost of a main photo. So, if the first or second relists go unsold, then the main photo costs for the second and/or third listings will be free. As soon as the item sells, Gallery Plus starts again for the next set of three. It costs a tickle more to opt for Gallery Plus.; You cannot opt for Gallery and Gallery Plus at the same time.
Feature: Set this to true/yes if you want your listings to appear near the top of the screen. When there are multiple listings all using the feature option then the listings that are due to close first will have the top most position. There is a charge from Trade Me for this feature.
Feature Combo: This isn’t a field you can import directly. When Gallery, Bold and Feature are all true, then behind the scenes we will set Feature Combo to true.
Super Feature: Set this to true/yes if you want your listings to appear as a super feature.
Listing Duration Type: This sets the listing duration type for each product. These can be fixed length listings or fixed length listings, which finish at a specific time or listings which finish on a specific day of the week and time.; We are looking for explicit matches on Fixed duration, Fixed duration specific end time or Specific day specific end time .
Listing Duration Days: This sets the listing duration for each product.; We accept the numbers 2 to 7 and 10. Alternatively, we are also looking for an exact match on 2 day, 3 day, 4 day, 5 day, 6 day, 7 day or 10 day (25c).
Listing End Day: Set this if you want your listings to finish on a specific day of the week and time.; We accept the explicit values of on Mondays, on Tuesdays, on Wednesdays, on Thursdays, on Fridays, on Saturdays or on Sundays.
Listing End Time: If you opted for Fixed duration specific end time or Specific day specific end time, then set your end time in 24 hour format, down to the nearest minute.; Eg, 19:47 or 20:10 or 08:13.
Automatic FPO Enabled: Set this to Yes if you want to make a Fixed Price Offer to any bidders on your sold or unsold listings.
FPO Bidders + Watchers: Set this to Yes if you want to also make a Fixed Price Offer to any watchers on your sold or unsold listings.
FPO Duration: We accept 1 day, 3 days or 7 days
FPO Is Absolute: Set this to Yes if you intend to offer a set price for the Fixed Price Offer.
FPO Absolute Value: If FPO Is Absolute was set to Yes, then this is where you should provide the fixed value for the Fixed Price Offer.
FPO Price Base Field: Defines the pricing foundation to use before applying the percentage from the FPO Base Field Plus Percent field.; We are looking for exact matches on Cost Price, Start Price, Reserve Price, Buy Now Price or Sell Price.
FPO Base Field Plus Value: This is the amount or the percentage to apply, using the FPO Price Base Field as a base. The amount or the percentage can also be a negative value.
FPO Base Field Plus Type: This tells us whether to apply the markup (or markdown) to the FPO Price Base Field as a fixed amount or as a percentage.; We are looking for explicit matches on amount ($) or percent (%).
FPO Ignore If Not Address Verified: Set this to Yes/True if you do not want to send an FPO to members who are not address verified.
FPO Ignore If Feedback Rating Below: Set this to Yes or True if you want to invoke a threshold that determines whether to send an FPO to members with a low feedback rating.; If you set this to Yes or True, then you will need to specify what your threshold is in the FPO Ignore Feedback Rating Below Percent field.
FPO Ignore Feedback Rating Below Percent: If you set FPO Ignore If Feedback Rating Below to yes or true then you will need to set a threshold percentage, that determines the lowest feedback rating that you are willing to send out an FPO for.
Disable automatic feedback: Set this to true or yes, if you don’t want positive feedback to be automatically responded to for this product.
Ignore feedback: Set this to true or yes, if you don’t want to bother with feedback for this product.
Payment Via Bank Deposit: Set this to true or yes, if you are happy for the buyer to pay by bank deposit into your bank account.
Payment Via Credit Card: Set this to true or yes, if you are happy for the buyer to pay by credit card. If you have more than 50 feedbacks you can apply to Trade me to use their Pay Now service, which substitutes for the credit card option.
Payment Via Cash: Set this to true or yes, if you are happy for the buyer to pay by cash.
Payment Via Afterpay: Set this to true or yes, if you are happy for the buyer to pay using Afterpay.
Other Payment Method: This is a text field where you can enter in another payment option that does not fit any of the standard options.
Pickup Options: We are looking for exact matches on the following pickup options: No pick-up, Buyer must pick-up, Buyer can pick-up. They are not case sensitive, so we will also accept buyer can pick-up, BUYER CAN PICK-UP etc.
Shipping Options: If you have downloaded your listings from Trade Me, then be aware that for the shipping options, our fields and format are different. You will need to format your data for our fields.; We are looking for exact matches on the following shipping options: Free shipping within New Zealand, Fixed shipping costs, Unknown shipping costs, Template Shipping Costs, Book a Courier Shipping Costs. They are not case sensitive, so we will also accept fixed shipping costs or FIXED SHIPPING COSTS etc.
Shipping Template: If you have created and want to use a shipping template, then specify the name of the template to use.
Shipping Details: This sets the shipping costs when Shipping Options is set to Fixed shipping costs.; We use the following semi-colon separated format syntax:; Cost=value1, Name=value2, Type=value3;Cost=value4, Name=value5, Type=value6; Eg. Cost=6.78, Name=Snail Mail, Type=Post;Cost=12.34, Name=Overnight courier, Type=Courier;Cost=0.00, Name=Free shipping with Buy Now, Type=Free Shipping; Each set of cost, name and type should be separated with a semi-colon. The cost should not include a currency symbol like the $ (dollar) symbol.; The acceptable Type values are: Post, Courier, Collection, Free Shipping, Own Transport, Freight
Book A Courier Use Box: Your options are bag or box. Set this to true or false. True = box and false = bag.
Book A Courier Bag Size: If you set Book A Courier Use Box to false then your bag size should be one of the following: Very small bag (25 x 13 cm max), Small bag (28 x 18 cm max), Medium bag (33 x 25 cm max), Large bag (45 x 36 cm max) .
Book A Courier Specific Courier: Set this to one of the following: Courier with best price, CourierPost only, Fastway only.
Book A Courier Service Level: Set this to one of the following: Service level with best price, Non-signature, Signature.
Book A Courier No Restricted Items: Book a Courier should only be used for products which are not on the restricted shipping list. Set this to true for Book a Courier to work.
Exclude Shipping Promotion: Set this to Yes/True if you want to exclude the product from the free shipping offer on your shopping cart.
Donation Recipient: You can opt to donate the rounded up portion of your success fee when the product listing sells. The portion to donate is based on the difference when rounding up to the nearest dollar. So if the success fee was for $3.83, then the donation would be for $4.00 – $3.83 = 17 cents.; You need to specify the name of the cause to donate to. The accepted values are either Plunket or Kiwis for kiwi.
Variant Group Code: If your product is a multi-variant product which offers dropdown options on the listing then you should give the group a name.; 80 chars.
Variant Shared Photo Identifier: This is the default photo for the multi-variant group.; Each product will still also have it’s own photos from the product itself (if required).
Variant Option 1 Name: The name of your 1st dropdown selection.; Only required if you have opted for a multi-variant product.; 100 chars.
Variant Option 2 Name: The name of your 2nd dropdown selection if you need a 2nd dropdown option.; Only required if you have opted for a multi-variant product.; 100 chars.
Variant Option 3 Name: The name of your 3rd dropdown selection if you need a 3rd dropdown option.; Only required if you have opted for a multi-variant product.; 100 chars.
Variant Option 4 Name: The name of your 4th dropdown selection if you need a 4th dropdown option.; Only required if you have opted for a multi-variant product.; 100 chars.
Variant Option 5 Name: The name of your 5th dropdown selection if you need a 5th dropdown option.; Only required if you have opted for a multi-variant product.; 100 chars.
Variant Option 1 Value: The text value to display in the 1st dropdown which is unique to this product row.; 100 chars.
Variant Option 2 Value: The text value to display in the 2nd dropdown which is unique to this product row. Only required if you opted for a 2nd dropdown.; 100 chars.
Variant Option 3 Value: The text value to display in the 3rd dropdown which is unique to this product row. Only required if you opted for a 3rd vdropdown.; 100 chars.
Variant Option 4 Value: The text value to display in the 4th dropdown which is unique to this product row. Only required if you opted for a 4th dropdown.; 100 chars.
Variant Option 5 Value: The text value to display in the 5th dropdown which is unique to this product row. Only required if you opted for a 5th dropdown.; 100 chars.
Variant Shared Attributes: If you have attributes which are common to all the products in your multi-variant product then detail those here and separate each attribute with a semi-colon.; If you have attributes which are specific to the product then detail those in the Trade Me Category Options field.; Semi-colon delimited list up to 4000 chars.
Variant Option 1 Sort Order: This is the order the text values should be displayed in the 1st selection dropdown.; This should list all the values separated with a semi-colon. 100 chars.
Variant Option 2 Sort Order: This is the order the text values should be displayed in the 2nd selection dropdown. Only required if you opted for a 2nd dropdown.; This should list all the values separated with a semi-colon. 100 chars.
Variant Option 3 Sort Order: This is the order the text values should be displayed in the 3rd selection dropdown. Only required if you opted for a 3rd dropdown.; This should list all the values separated with a semi-colon. 100 chars.
Variant Option 4 Sort Order: This is the order the text values should be displayed in the 4th selection dropdown. Only required if you opted for a 4th dropdown.; This should list all the values separated with a semi-colon. 100 chars.
Variant Option 5 Sort Order: This is the order the text values should be displayed in the 5th selection dropdown. Only required if you opted for a 5th dropdown.; This should list all the values separated with a semi-colon. 100 chars.
Update Existing Active Listings: This fields tell us whether to update the details of any of your active listings, providing there are no bids on the active listing. Set your field value to true or yes, if you want us to try to update the listings. You can update each listing a maximum of three times.; Any failures will be reported in a downloadable warnings file at the end of the import.

Shopify fields

After the first import of your Shopify products into Tradevine, you may need to supply the External fields (Handle, Product ID and Variant ID) when re-importing.

Store Domain: On step 2 of the import we will auto populate the Apply this to all rows drop-down with all the Shopify webstores you currently have connected. So you can simply select the webstore that the import applies to, otherwise you will need to supply the domain name for your webstore. This can also include .myshopify.com. We will handle either.
Shopify Title: The products display title in plain text (not HTML).
Body HTML: The products description, which can be formatted as either plain text or HTML.; The description can be up to between 40,000 to 50,000 characters, depending on the extent of the HTML used.
Is Listed on Shopify: Defines whether the product exists in Shopify itself. This is not the same as the Is Published setting. We are looking for Yes, No, True, False etc. This field is extremely useful for adding or removing products from your Shopify store, especially when re-importing or resetting the published visibility for your auto-update products in bulk via the Products List.; NB: Setting the field to false/no will remove the product from both the Shopify Admin screens and the Shopify store which is visible on the web.
External Shopify Handle: Use this field only if you already have a Shopify store with products. You can get the Handle by exporting your products out of Shopify. We can then use the Handle from the export file to identify and match up the data from your existing products.
External Shopify Product ID: This field can be exported but can no longer be imported. Deprecated March 2016.
External Shopify Variant ID: This field can be exported but can no longer be imported. Deprecated March 2016.
Is Published: This field sets the visibility of your products on the web. The products will still be visible in Shopify in your Admin screens.; The first time you import you might want to set the visibility of all your products to False. Then when you have finished any further editing of your products, set the visibility of your products in bulk, via the Products List or re-import with Is Published (and Auto-update products on)set to true/yes.; NB: Is Listed on Shopify sets the existence of the product in Shopify in your Admin screens and your Shopify webstore(s).
Product Type: Lets you set the main Type for each product. The data should be at least 2 characters long.; The Type is especially useful if you use Smart Collections (a webpage that displays all the products that were added to the Collection) in Shopify. Smart Collections can be configured to target the Type.; NB: leaving this field blank does not mean the Type specified in your Settings > Shopify Settings screen will be used instead as a default.
Vendor: Lets you set the main Vendor for each product. The data should be at least 2 characters long.; NB: leaving this field blank does not mean the Vendor specified in your Settings > Shopify Settings screen will be used instead as a default.
Tags: These are the search tags you can specify for each product. Separate multiple tags with commas.; Eg, blue, kitchen, kitchen appliance, coffee, grinder; This field is optional.
Shopify Sell Price Inc Tax: This is the purchase price including any taxes, which you expect any buyers on the web to pay.
Shopify Compare At Price: This is regarded as the RRP (Recommended Retail Price). It is optional.
Shopify Allow Overselling: This allows you to sell products when there is no stock available. It is optional.
Shopify Photo Identifiers: Use this to reference the filenames or the URLs of the photos to display in Shopify. Leaving this blank will ensure there are no photos on your Shopify channel. Photos referenced on your product, but not here, will be available on your Shopify channel, but not selected and not visible in Shopify (unless this field was not mapped during the import, in which case the photos defined in the product’s photo identifier field will be selected and used). Photos must be referenced in the Product Photo Identifier field before they can be referenced here.; Multiple filenames and file paths should be separated with a semi-colon. The leftmost filename will be the main photo used in Shopify. Photos will be uploaded and displayed in the same order that you list them in. Photos that have been stated on the product, but not here, will be available, but unselected.; If you are uploading from a website then you can enter the URL path in either HTTP or FTP format. Eg, http://www.uvxyz.com/uploads/54321.jpg or ftp://username:password@ftp.somesite.com/image/image.jpg
Shopify Weight Override: The weight is in grams
Use this field when you need to include the packaging weight or you need some leeway on Shopify’s quantity versus weight set ups.
Shopify Option Name1: If you use multi-variants, then this is the name of the first attribute. It is optional.
Shopify Option Value1: If you use multi-variants, then this is the value of the first attribute. It is optional.
Shopify Option Name2: If you use multi-variants, then this is the name of the second attribute. It is optional.
Shopify Option Value2: If you use multi-variants, then this is the value of the second attribute. It is optional.
Shopify Option Name3: If you use multi-variants, then this is the name of the third attribute. It is optional.
Shopify Option Value3: If you use multi-variants, then this is the value of the third attribute. It is optional.
Shopify Variant Sort Order: If you use multi-variants, then this is the sequence to display each of the variant attributes. This is a numerical ordering sequence. Each variant should have a solitary unique number. It is optional.

Data formats

Boolean: Never heard the term before, that’s good, you pass the “I’m not a geek” test. These are essentially true or false values. Eg, TRUE, Yes, Y, 1 or FALSE, No, N, 0
Decimal: These are basically monetary values or decimal values represented as just numbers and an optional period character. Eg, 10 or 10.1234. If the field is a monetary type field, we can sometimes also handle the currency character. Eg, $10.12
Integer: These are numbers within the range -2,147,483,648 to 2,147,483,647. We tend to be interested in the positive numbers within this range.
Short Integer: These are numbers within the range -32,768 to 32,767. We tend to be interested in the positive numbers within this range.
Special Symbols: You can import special symbols like the copyright and trademark symbols etc. If you intend to use these symbols then you will need to save your import files in UTF-8 format unless there is an HTML entity code that you can use.