IMPORT / EXPORT PRODUCTS

You can import and export your products via CSV from your Nimbl Portal. Please note that this is an advanced feature and should not be used if you are not familiar with CSV files. Products imported can not be reversed and must be manually removed if incorrect data is found.

Import Products

You have the ability to mass import your products from a CSV file. Please note that imports loaded and completed can not be reversed and should you not be familiar with CSV files it could have unintended consequences.

To import your products:

• Navigate in the menu to Products> Import/Export

• Under the "Import New CSV" tab click on the "Select CSV File to Import" button. Here you can choose your CSV file to be imported.

• After you have selected your CSV file you can click on the "Import Products" button.

You import will be scheduled. Once the import is completed you will be notified of email. You can navigate to the Import/ Export page again to see the result of your import which will show you if there were any issues with some of the lines of your import.

IMPORTANT

If your CSV file does not contain valid data your import will fail. Ensure valid data and use our example CSV which can be downloaded from the Import page to see which data is required. Should any fields be invalid or missing, import will fail with message stating what the reason was for failure. Please amend CSV and re upload missing items.

Please see information regarding fields below:

• Handle: This is a unique string name to be associated with your product. It is usually the product title with no spaces. This will also be the URL of the product on your website. This has te be unique and can not be the same as any other product in your store.

• Line Type: P for product or V for variant of a product. If V (variant) is used please ensure the handle of this line matches the main product handle

• Title: Title of product. Not relevent for Variants

• Description: Description of product. Not relevent for variants

• Published: TRUE or FALSE. No spaces. Not relevent for variants

• Featured: TRUE or FALSE. No spaces. Not relevent for variants

• New Release: TRUE or FALSE. No spaces. Not relevent for variants

• Google Category: As per Google Category List. Not relevent for variants

• Sell Price: The price at which this product sells on your website. Not relevent for variants

• Compare at Price: The compare at price(sale) price

• Cost per Item: For reporting purposes only

• VAT: TRUE or FALSE. Not relevent for variants

• SKU: Stock Keep Unit number. Not relevent for variants

• Track Inventory: TRUE or FALSE. Not relevent for variants

• Sell Out Of Stock: TRUE or FALSE. Not relevent for variants

• Lead Time: For display purposes on website

• Ship Weight: To be used to calculate courier costs of integrated courier is used. 

• Image 1/2/3 URL: if URL of image is availalbe to be downloaded by system and added as product image

• Has Variants: TRUE or FALSE. If TRUE please also add variant details in seperate line with matching HANDLE and LineType V

• Option 1/2/3: Variants options Name and Value 

• Variant Price: Sell price of the Variant

• Variant Cost: Cost of variant to be used for reporting purposes

• Variant SKU: Stock Keep Unit number of variant