Follow

Import / Upload Products (CSV) with the Import Tool

Overview:

Acenda's import tool is in efficient way to add products or make changes to your database.

If you're an advanced user then you may want to consider using the REST API to add products to gain some additional flexibility.  Most users will be content using CSV Import Tool.  

TIP: We recommend practicing import with a staging store prior to importing into your production website. You can easily create a new store in Acenda by clicking on the globe icon Screen_Shot_2017-06-15_at_9.29.14_AM.png in the header of Acenda Admin and select "Create New Store". 

To add/modify products to your Acenda stores by follow the steps below:

1. To access the latest product template, we recommend visiting the Acenda Admin Tool > Products > Products and click the Export button.  This will generate a CSV file that you can open in MS Excel or Google Docs. 

Important Note: 1) Remove extra spaces, special characters (eg. Æ), and converted code from your spreadsheet prior to import.  2) Also, we recommend that your sort your variants in the order that you want them to appear on the store product page, eg. X-Small, Small, Medium, Large -- this will facilitate integration with marketplaces.

The product model contains the following common fields.  And, if you're an advanced user then you can always add/update your own custom fields here too.

Field

Description

 

slug 

URL slug is the exact address of a specific page on your site

status 

Active, Disabled

name 

The name of your product

category 

The location(s) where you want your product to appear

collection_id 

This is an optional field. Click here for an example of a Collection. Enter the "collection id" that you want to assign the product to. It's important that the Collection exist first.  To create a collection: visit Admin > Products > Collections and create a new Collection.

 

 

brand 

The brand name or manufacturer of the product

type

The product type (e.g. sheets, duvet covers, towels)

tags 

The promotional tags for your products (e.g. Sale, New)

description

The product description (supports HTML). 

options 

How you want the variant options to be sorted on the product page Note: the exact order of the options is respected (e.g. Size, Color, Material)

images 

The image URL's, separate multiple images with commas. Now, this is super cool and powerful :) By default, Acenda supports three image types: 1) Default 2) Alternate and 3) Swatch.  The first image uploaded is assumed to be the "Default" image unless you specify it to be a different type.  

Here's an example of how to specify image type: http://linktomynewimage.jpg#acenda_image_type=swatch

Now, things get really exciting because you can create additional image types.  For instance, you may want the image for your Amazon Store to have color chips embedded in the image.  You can do that by creating a new image type: http://linktomynewimage.jpg#acenda_image_type=standard_with_swatches

 

videos 

The video URL's, we support YouTube and Vimeo video file formats.

popularity 

Acenda updates this variable based on sales history.  Greater values represent more popular products.

page_title

The meta tag title

meta_description 

The meta tag description

keywords 

The metatag keywords

date_publish 

Data/time that you want the product to be active (e.g. 9/30/17 14:23). Leave blank if you want it active without date/time restrictions

date_expire 

Data/time that you want the product to expire (e.g. 10/30/17 14:23). Leave blank if you want it active without date/time restrictions

variant.status 

Active, Disabled

variant.name

Product variant name

variant.sku

fulfillment sku

variant.asin

ASIN (amazon) number

variant.ean

European Article Number

variant.isbn

Publisher identification code numbers

12 or 13 digit value (Tip: if you're using MS Excel: Right click the column header and choose 'Format cells'. In the dialog that appears, choose Text.)

variant.barcode

Publisher identification code numbers

12 or 13 digit value (Tip: if you're using MS Excel: Right click the column header and choose 'Format cells'. In the dialog that appears, choose Text.) Also, note that 13 digit barcodes do not start with a zero (0).

variant.cost

Cost of the item (Tip: do not include currency symbols, e.g. $)

variant.price 

Selling price of the item (Tip: do not include currency symbols, e.g. $)

variant.compare_price 

Compare price or MSRP of the item (Tip: do not include currency symbols, e.g. $)

variant.image 

The product variant image(s)

variant.inventory_quantity

Quantity on hand

variant.inventory_minimum_quantity

The minimum quantity on hand threshold for the item to appear as In Stock

 

variant.inventory_tracking

if you want to track inventory (1=Yes, 0=No)

variant.inventory_policy

Deny = prevent customers from ordering when inventory levels are below variant.inventory_minimum_quantity; allow = allow customers to order even when the item is out of stock; disable = disable the item when it's out of stock.

variant.inventory_shipping_estimate

When the item is sold out then display the estimated backorder shipping timeframe, e.g. Ships in 2 to 4 weeks.

variant.inventory_returnable

Identify if the item is returnable (1=Yes, 0=No)

variant.require_shipping

Shipping rates apply to this item (1=Yes, 0=No)

variant.discountable

If the item is discountable (1=Yes, 0=No)

variant.taxable

If the item is taxable (1=Yes, 0=No)

variant.weight 

the weight of the item

variant.date_publish

Data/time that you want the product variant to be active (e.g. 9/30/18 14:23). Leave blank if you want it active without date/time restrictions.

variant.date_expire

Data/time that you want the product variant to expire (e.g. 9/30/18 14:23). Leave blank if you want it active without date/time restrictions.

variant.color

The color name of the product variant (e.g. Green)

variant.size

The size of the product variant (e.g. Extra Large)

variant.popularity 

Acenda updates this variable based on sales history.  Greater values represent more popular variants.

variant.position

The order you want the product variants to appear on the page. We recommend using increments of 10 if you add additional variants down the road. Useful for organizing items with sizes: e.g. Small, Medium, Large.

amazon_listing 

Set to true if you want the item to be eligible for sale on Amazon.com.  

If you wish to add Custom Attributes:

  • Product Level: add columns to the spreadsheet, eg. genderthread_count, machine_washable.
  • Variant Level: add columns to the spreadsheet with the prefix "variant.", eg. variant.material or variant.voltage.  

2. Save your MS Excel or Google Docs file as Windows Comma Delimited (CSV).  

Note: the file size limit is 20.0 MB per upload.

3. From the Acenda dashboard click Import
The IMPORT page displays.
4. Select Product (not Product Variant) from the Model drop-down

5. Click Upload a File

Note: If you're performing a first-time product import the you must leave all the matching fields ("Match existing models by this field") unchecked.  

However, if you're performing an update to products that already exist in your Acenda product database then you must check the checkbox for the appropriate matching field e.g. variant.sku or variant.barcode.  Only check one field per import.
Acenda automatically queues each import.  You can track the progress of each import by visiting the blue Process Indicator located in the header of the Admin tool.
sample product import.csv (4kb)

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk