Import - UPC

This article shows DVU users how to bulk upload UPC codes for items with the Import tool. It’s a four-step process:

1. download the CSV template

2. add rows of data

3. import the file

4. verify UPCs

Downloading the template

Go to Home > Import and then:

1. Click the Import Type field and select UPC.

2. Enter the Account ID.

3. Click Download Template. The file saves to the local device.

Adding data

Open the file and enter the required data. Add one row for each UPC. Save the file with a unique name.

The file has many data columns. The following columns are required:

• Item code

• UPC

• UOM (Each, Case, or Innerpack)

• Cases Per Pack (if the UOM is Innerpack or Case)

Importing the file

1. Open the Import page.

2. Select the file on the local device.

3. Click the Import button and then OK in the confirmation popup window.

DVU loads the data into the table but not into the system. If the data looks complete, click the Import button. DVU moves the data to the UPC database. (next step)

Troubleshooting

DVU displays an error message like this when it cannot find an item code in the account or the UOM type is entered properly.

If the page displays an error message:

1. Go back to the original CSV file, make changes, and save the file.

2. Come back to the Import page and click Choose Import file. DVU removes the rows of table data on the screen.

3. Import the updated CSV file.

Verifying the import

To confirm the UPC import, go to the UPC module and search the account. The main page displays the item codes and matching UPCs.