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 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 Product 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.

01.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 the ones that have been 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 imported.

Click Edit on the first product to view the problem.

02.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.

03.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.

04.png

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

05.png

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

06.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.

07.png


    • Related Articles

    • Troubleshooting Excel Errors

      When importing an Excel 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 ...
    • Troubleshooting Excel Errors for products

      When importing an Excel 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 ...
    • 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 Hike Plus subscription ...
    • 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. Note: We do not recommend using Google Chrome in Incognito mode. This may cause an issue when ...
    • Importing Products 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 ...