Troubleshooting CSV Errors

Troubleshooting CSV Errors

When importing a CSV file into Hike, a missing field or incorrect data will cause errors and for your products to be not being synced. Fortunately, Hike makes it easy to rectify any such errors for a quick fix.

On this page we’ll go through how you would troubleshoot such CSV errors.

Note: Whilst the example used here will be an error on a Products CSV file, the same steps apply for both Suppliers and Customers import files.

Firstly, you will notice any errors in your Record Log after you have completed the mapping of your CSV data fields to Hike.

00.png

Under status you have two options:

  • View and Fix Errors
  • Download Records with Error

By clicking View and Fix errors, you will get a full breakdown of the products that have problems with their syncing and ones that have imported successfully.

At the top of the screen you will see three boxes:

  • Problems Found – The number of products that have been unsuccessful in importing.
  • A-OK – The number of products that have been successful in importing.
  • Total Records – The total number of products that are to be imported from your CSV file.

Under Records, will appear all the products that have not been successful in importing.

Click Edit on the first product to view the problem.

01.png

Hike will then direct you to the product record details – this will appear in the form of Hike’s template, regardless of whether you used it or not.

The specific problem related to your product will be described in red at the top left of the screen.

In the example below, the problem states that a Variant is required.

02.png

Scrolling down to the variant section of the Product Records shows that whilst a variant option value was listed in the CSV file, a variant option name was not.

Enter the missing value and click Save & Next to go on to the next problem.

03.png

Once all issues are fixed click on Save & Finish, where you will then be taken back to the Import/Export screen.

04.png

Your CSV upload will still show errors in the Result column, however you need to click Reprocess in Status, to activate the changes.

05.png

As the changes are syncing, use the Refresh button to see the latest updates. If successfully fixed, you will then see the status as Processed, with all your imported items in Hike POS.

06.png

    • Related Articles

    • Troubleshooting CSV Errors

      When importing a CSV file into Hike, a missing field or incorrect data will cause errors and for your products to be not being synced. Fortunately, Hike makes it easy to rectify any such errors for a quick fix. On this page we’ll go through how you ...
    • Import label print list using Hike label print CSV

      You can import label print list in Hike. This feature is useful for you when creating labels for 100s of products in one list and/or labels for a same list of products are printed on regular basis. This feature is available on One store and Multi ...
    • Hike Troubleshooting - When And How To Refresh Hike And Clear Your Browser History (Google Chrome)

      Hike recommends using Google Chrome on Mac or PC for the best results; however, sometimes you may get stuck. The following steps should help get you going. REFRESH HIKE A refresh of data is required after any changes have been made to the back-end of ...
    • Importing Customers via Excel File

      Importing your Customers via Excel file When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can ...
    • Importing Suppliers via Excel Files

      When businesses are moving to Hike POS, rather than having to manually create all their data – products, customers & suppliers – it may be preferable to have all information stored onto a spreadsheet, that can then be imported into Hike. This ...