Using CSV File to Upload Products

Importing your Products via CSV file

You can upload your CSV file to Hike, or download the template to complete a spreadsheet.

Hike CSV checker will look for some of the most common import errors in your CSV file before it imports into your store.

How does it work?

When you choose to add or update products using a CSV file, Hike will run a quick check on your CSV file. It will check for any formatting issues or errors such as column headings and mandatory fields and let you know if any of these errors are present in your CSV file.

Hike will import all the working entries, and give you the on-screen option of editing all the entries with errors.

How do I do it?

To validate and import your product CSV you must first navigate to the Hike Product page in the sidebar. Once there, follow these steps:

In the Product section, click on IMPORT/EXPORT Button

You will be able to upload your spreadsheet, or offered to download the CSV template to complete

When uploading the file, a window will slide out with two columns

On the left is the column headers in your file

On the right are the column headers that Hike uses

If any Hike column headers are incorrect or unknown, use the drop down menu to change

Once completed mapping your spreadsheet, click Continue

Hike will check your file, import successful entries and make a list of any unsuccessful entries

You will be able to correct the unsuccessful entries on-screen

Once successful, you will be taken to a confirmation screen to verify all done

Important: If you have product variants in your CSV file, you will need to ensure you have a column entitled Is Variant Product, and that all Variant products are listed as TRUE in your Excel file.

Guide to CSV spreadsheet Column Headers

This guide describes what each column header means and if it is necessary.

Name (Mandatory)

The name of your product. You can have letters, numbers, and symbols in this field.

Description (can be blank)

The description of your product.

SKU (Mandatory)

The Stock Keeping Unit for your product. Every product must have a unique SKU up to 20 characters long. If the SKU consists of pure numbers, no letters, Excel will convert it to scientific notation and eliminate the at start digit. Please note we will update our notes how to address this.

Barcode (can be blank)

The barcode of your product. You can leave it empty, and generate it automatically in Hike. If the barcode consists of pure numbers, no letters, Excel will convert it to scientific notation and eliminate the at start digit. Please note we will update our notes how to address this.

Specification (can be blank)

This field is in development. Please leave it as empty for now.

Depth (can be blank)

This field is in development. Please leave it as empty for now.

Width (can be blank)

This field is in development. Please leave it as empty for now.

Height (can be blank)

This field is in development. Please leave it as empty for now.

Weight (can be blank)

This field is in development. Please leave it as empty for now.

Weight Unit (can be blank)

This field is in development. Please leave it as empty for now.

Color tag (can be blank)

This field is in development. Please leave it as empty for now.

Color type (can be blank)

This field is in development. Please leave it as empty for now.

Brand name (can be blank)

This field is in development. Please leave it as empty for now.

Season name (can be blank)

This field is in development. Please leave it as empty for now.

Enable account sync rule (can be blank)

This field is in development. Please leave it as empty for now.

Supplier code (can be blank)

This field is in development. Please leave it as empty for now.

Sales code (can be blank)

This field is in development. Please leave it as empty for now.

Purchase code (can be blank)

This field is in development. Please leave it as empty for now.

Inventory asset code (can be blank)

This field is in development. Please leave it as empty for now. Used for Xero integration. If you want stock orders of this product to post to an account other than your default purchases account, add the account code you’d like to post to here. Leave it blank to use a default, or if you don’t use Xero.