Advanced CSV Bulk Import
The Advanced CSV Import tool gives you the ability to bulk import thousands of new items, create listings and activate them on multiple channels, all with just a single file. This import method gives you complete control over how your eBay, MoreCommerce and/or Facebook listing are created, with the exception of Amazon; your Amazon listing will contain the information associated with the provided Amazon ASIN(s). This is especially helpful for brand owners who have unique product details, or even for those of you who just have specific images, titles or item descriptions you want to use within your listings.
This tutorial will show you how to input your product and listing information into the import file, upload it to Auctiva, and publish the listings on all desired channels.
Step 1: Download the Advanced CSV Import file template
To get started, hover over "Products" in the top navigation bar, and go to the CSV File Import & Editor page (Figure 1).
Click on Importing New Products (Figure 1.1A) and then select the Advanced CSV Import option (Figure 1.1B).
With the Advanced CSV Import option expanded, select the category that best matches the set of items you want to import (Figure 1.2A) and then click on Example Template File (Figure 1.2B) to download the template file.
Step 2: Input your items' information into the import file
Locate the downloaded file; generally you can find the file within your computer's download history. Open the file and input your items' information. Below you will see examples of what the acceptable values are for each column (Figure 2).
- Use this reference page to find the Category ID. Locate the most recent file and download it to view the list of Category IDs.
- Use this reference page to determine the Condition ID for the specific category and condition you're listing the item(s) under.
|
Column Header
| | sku | Required | Less than or equal to 40 characters
Alphanumeric, spaces & special characters |
| title | Required | Less than or equal to 80 characters
Alphanumeric, spaces & special characters |
| upc | Optional | Numbers |
| isbn | Optional | Numbers |
| asin | Optional
Required if posting to Amazon | 10 characters
Alphanumeric |
| condition | Required | Numbers (condition ID) |
| condition_for_amazon | Optional
Required if posting to Amazon | "New", "Used", "Collectible", "Refurbished" only |
| condition_description | Optional | Alphanumeric, spaces & special characters |
| category_id | Required | Numbers (category ID) |
- ebay_store_category_1
- ebay_store_category_2
| Optional | Alphanumeric, spaces & special characters
Must exactly match your eBay store category name |
| item_description | Required | Alphanumeric, spaces & special characters |
item_weight_lbs
- item_weight_lbs
- item_weight_oz
- item_dimensions_length
- item_dimensions_width
- item_dimensions_depth
- image_url_7
- image_url_8
- image_url_9
- image_url_10
- image_url_11
- image_url_12
| Optional
Required if using calculated shipping | Whole number |
| image_url_1 | Required | URL |
- image_url_2
- image_url_3
- image_url_4
- image_url_5
- image_url_6
- image_url_7
- image_url_8
- image_url_9
- image_url_10
- image_url_11
- image_url_12
| Optional | URL |
- auto_synced_qty
- allocated_qty_ebay
- allocated_qty_amazon
- allocated_qty_morecommerce
- allocated_qty_facebook
|
Required
Either fill out "auto_sync_qty", OR "allocated_qty_channel" for each channel you want to list the item on.
If a value is entered into "auto_sync_qty" and "allocated_qty_channel" for an item, the "auto_sync_qty" value will take precedence.
| Whole number |
- price_ebay
- price_amazon
- price_morecommerce
- price_facebook
| - Required IF posting to eBay
- Required IF posting to Amazon
- Required IF posting to MoreCommerce
- Required IF posting to Facebook
| Numbers and period |
| ebay_best_offer_enabled | Optional | To enable: "yes" or "1"
To disable: "no", "0" or leave blank |
- ebay_best_offer_autoaccept_price
- ebay_minimum_best_offer_price
| Optional | Numbers and period |
| ebay_shipfrom_zipcode | Required IF posting to eBay | Alphanumeric |
- standard_shipping_cost
- standard_shipping_add_item_cost
| Required IF posting to MoreCommerce | Numbers and period |
- activate_ebay
- activate_amazon
- activate_morecommerce
- activate_facebook
| Optional | To activate: "yes" or "1"
To save as draft: "no", "0", or leave blank |
Step 3: Save the completed file in a .CSV format
Once you've input all of your item information into the import file, save it as a .CSV Figure 3.
Step 4: Upload the file & select your offer settings
Upload the completed import file by clicking the Browse Files button (Figure 4A) within the Importing New Products view, or by dragging and dropping the file into the upload box (Figure 4B).
Select the Advanced Template Type option (Figure 4.1A) and then set your offer details. Select which Amazon Shipping Template you want applied to the imported items (Figure 4.1B). If you do not want to post the items to Amazon, you can leave this empty. Select which eBay Shipping, Payment and Return Policies you want applied to the imported items (Figure 4.1C). If you do not plan to post the items to eBay, you can leave this empty. Lastly, to submit the file for processing, click the "Import Products File Now" button (Figure 4.1D).
Step 5: Verify the results
Verify your file's import results by reviewing the CSV Event Log located on the CSV Import page. To view the status of your import file, refresh the CSV Event Log by clicking on the refresh button (Figure 5A). Once the file has completed, verify the number of products that were processed successfully by reviewing the Successfully Processed column (Figure 5B). Then review the Error Report column to see if the file resulted in any warnings or errors (Figure 5C).
All items that were successfully processed will be reflected in your Auctiva Product Catalog.