Importing listings with a CSV file
So you've set up your store, you've started customizing your storefront, and now you want to start listing your products. If you have more than 20 products, the processing of uploading and entering in all that information can be time-consuming. Using the import from CSV file feature can save you a lot of time. This is especially useful if you already have your product information stored in another system.
Accepted CSV file formats
When importing your products using this function, it is important that your file is saved as a .csv file. You can manage a CSV file using any spreadsheet app, like Google Sheets, Microsoft Excel, Apple Numbers and the like.
There are a number of CSV file formats which are supported by AllGoods. These formats include CSV files exported from:
- Trade Me's "My Products"
- Big Commerce
If you are not importing a CSV from any of these platforms, there's no need to worry! AllGoods has its own CSV format which you can use to import your products or auctions.
If you are importing product listing, download the AllGoods products CSV template here.
If you are importing auction listing, download the AllGoods auction CSV template here.
Preparing your CSV file
Each line in the sheet represents an individual listing. The first row at the top should be your column titles. You should try to have as many of the columns filled in as possible before you begin the upload. However, there are certain fields which can be added or edited at a later step in the CSV upload process.
These include the listing title, price, stock, category, item specifics, description and images. In many cases, the category and images are easier to add during the CSV upload process as opposed to adding them into the CSV file before you upload it.
The system will automatically detect whether your CSV file is for products or auctions.
Note: You can find a list of district IDs here: https://allgoods.co.nz/api/regionList
You can find a list of category IDs here:https://allgoods.co.nz/api/categoryList
You can find your shipping template IDs by viewing them through your inventory manager.
Step One: Go to Store Manager > Inventory Manager and click Import from CSV.
Note: Your Inventory Manager is different from your Storefront. The 'Inventory Manager' page is where you manage all your stock and product details. Your 'Storefront' page is the public's view of your store. You will find your Inventory Manager by clicking on the top right MENU, select 'Store Manager' and then click 'Product Management'.
Step Two: Review a few details, then click Next.
Step Three: Upload your CSV file, then click Next.
Step Four (OPTIONAL): Add your images. If you have already added your image file names into your CSV, then this is where you upload these images. The image file names must match exactly. If you prefer to upload the images for your listings individually, you'll have the option to do this in a later step.
Step Five: Preview your CSV format, then click Next. This will display the first three rows of your CSV file so you can check that AllGoods is reading the file correctly.
Step Six: Edit your products. This is the most time-consuming step in the import process. During this step, you will need to add the images for each product, as well as the category and any item specifics you wish to include. You can bulk update the category for each product by selecting a range of products and clicking Bulk Edit Categories.
Products will display on this page in groups of 20. Each time you click Save, all products which have their category added and at least one image uploaded will be automatically saved into your Inventory Manager.
Updating existing listings through CSV
Both the Trademe (My Products) as well as the AllGoods CSV formats can be updated through the CSV import function. To use the CSV import function to update existing listings, the CSV file will need to have the listing ID field filled in. That's the "allgoods_id" column for both CSV formats. We'll use the listing ID to decide what to update, so make sure that the ID is correct because the existing listing on AllGoods will be updated to match the information in your CSV file.
When updating your listings through a CSV import, the easiest way is generally to first export your current inventory from AllGoods to make sure the details in your CSV are all up to date. Once you have your exported CSV file, edit and add any information you wish, then re-import the file.
For brand-new product listings, the following fields will be updated:
- shipping_template_id (Note, this id can be found by viewing your shipping templates in the inventory manager)
- combine_shipping_with_other_listings (Note: this means only change shipping once if it is combined with other listing in a cart order)
- combine_shipping_for_multiples (Note: this means only charge shipping once for any quantity purchased)
- folder_id (Note: you can see the folder ids by cliking on the "Create/Edit Folders" button in the inventory manager)
For secondhand auction listings, the following fields will be updated:
A few things to take note of...
- Once you have clicked "Save", all products that have all required fields added automatically be added to your Inventory Manager.
- Products added through CSV Import are created as "paused" - you'll have to activate them through your Inventory Manager later.
- Once an auction has been bid on, it can no longer be updated through the CSV upload.
AllGoods mate ;)