To export inventory quantities by location and then upload an adjustment for a certain location using DataEase, follow these steps:
Export Inventory Quantities by Location
1. Export Products:
-
In the DataEase app, go to the "Export" section.
-
Select "Products" from the "Select Sheets" drop-down.
-
Check the following checkboxes:
-
Basic Columns
-
Inventory / Variants
-
Multi-Location Inventory Levels
-
Click the "Export" button to start the export process.
2. Download and Review the Exported File:
-
Once the export is complete, download the exported file.
-
In the file, you will see columns named Inventory Available: ... for each location, showing the inventory quantities for each product variant at that specific location.
Upload an Inventory Adjustment for a Certain Location
1. Prepare the File for Import:
-
Open the exported file and delete unnecessary columns. You only need the following columns:
-
ID
-
Handle
-
Variant ID
-
Variant SKU or Variant Barcode (optional, but preferred for easier identification)
-
Inventory Available Adjust: [Location Name] (replace [Location Name] with the actual name of the location you want to adjust)
2. Adjust Inventory Quantities:
- In the Inventory Available Adjust: [Location Name] column, enter the adjustment quantities for each product variant. Use positive numbers to increase and negative numbers to decrease the inventory.
3. Import the Adjusted File:
-
Save the updated file.
-
Go back to the DataEase app and import the file in the "Import" section.
-
The app will analyze the file and count how many products you are importing.
-
Press the "Import" button to start the import.