Importing Product Quantities

This article will explain how to add quantities via an import file

Adding Quantity via an import file

1. From the Aptimyz Back Office, go to Inventory > Imported Tables

   

   

2. Select "Import" > Import Store Quantity

 

3. Download Quantity spreadsheet by using the link shown 
4. Fill in the Stock id OR the SKU field

5. Fill in Quantity (and Tax Group, if required)
6. Save as a CSV UTF-8 file or .xlsx file

Importing Store Quantity 

1. Return to Step 2 above from Store Level and select Import Stock Quantities
2. Select Continue 
3. Select Add file or drag and drop your file  
4. Continue 
5. From this screen, you can confirm that the columns match up and that the Table's Row Value will be imported correctly
   
   
6. Select Continue and Proceed
7. If there are no errors on the sheet Import will be highlighted
8. Select Import and Proceed 
9. If Import is not highlighted, select Edit and amend any missing information highlighted in red
10. The status of your import can be checked at any time 
11. Once complete, the status will amend on the screen to Done! 
    

Using a Report to Identify the Product Information

1. Login to Aptimyz Back Office
2. From the Main Menu select Report > Inventory
3. Create the following report:

                 Data Fields:

• • a) Item No
  • b) Barcode
  • c) Product
  • d) Variation
    

4. Generate Report
5. Export to Excel
6. Once you have identified the products you need in the import file, either copy and paste the Item No (stock id) or the SKU column and add the quantity and tax group to the import file.

Importing Multi Store Quantities 

If you're operating a business with multiple store locations, you'll likely observe variation in item availability across the different stores. We've made managing these variations easier for you! Watch the tutorial video below to learn how to effortlessly update item quantities for each location.

 

 

This is the end of the article