Instead of adding information one entry at a time, you can import information in bulk by using a CSV file.
​
​Note: Bulk imports can lead to serious problems if not performed properly; please only perform a bulk import on the advice of an Abacus Support member. We recommend only users with advanced spreadsheet knowledge to use this feature.

In this article:

2. Under Import, select the kind of information you want to import
3. Click Download a sample CSV file for reference to retrieve the correct template
4. Fill in the template according to your own needs

Note: You can also cross-reference this with an exported CSV file, but please note that exported CSV files may use a different format to importable CSV files. It is best to use a sample to make a compatible CSV file.

5. Click Select CSV File. Choose the CSV file you have edited.
6. Click Import.

You can't bulk import product images using the standard product import procedure above. You'll need to import product images separately.

Note: product images must be .jpg or .png files, with dimensions 861 × 600 px.

4. Under Product Images, click SELECT FILES and upload the zip file.

5. Perform a Menu Sync on your Abacus POS, and the images will appear.

To bulk import product variant group images, click SELECT FILES under Product Variant Group Images. Zip all the images into a zip file (.zip) prior to upload. There should be no folders in the zip file, only image files. Make sure image names, including extensions (.jpg, .png), match exactly as they are written in the "Value Images" column of the product variants CSV file.

Photos must be uploaded as .jpg or .png files, with dimensions 861 × 600 px

At times, you might receive an error for a CSV file whose import has failed.

If a bulk import has failed, you will automatically download a "DataNotImport" CSV file that will contain the reasons why your CSV import had failed.

The CSV file will tell you which Row and Field had the issue, and the Reason why, e.g. a username may have already been taken
​Note: The row "count" excludes the header row, e.g. if your erroneous data is in row 2 of the spreadsheet, this will be counted as row 1, because that's the first row of the actual information you are importing. This is the case in the example below.