Import Pickware Product Stock
Use Pickware Product Stock import when you want to update Pickware ERP stock settings for existing Shopware products.
Each row in the import file should identify one product and provide at least one Pickware stock field to update.
Before You Import
Section titled “Before You Import”Prepare a file with one row per product stock record.
Include one of these product identifiers:
| Field | Use |
|---|---|
productNumber | Product number of the Shopware product. This is the recommended identifier for most imports. |
productId | Shopware product ID. Use this when your source system already stores Shopware IDs. |
Then add the Pickware fields you want to update.
| Field | Expected value |
|---|---|
reorderPoint | Integer. |
targetMaximumQuantity | Integer. |
isExcludedFromReorderNotificationMail | Boolean, such as true, false, 1, or 0. |
isStockManagementDisabled | Boolean, such as true, false, 1, or 0. |
shipAutomatically | Boolean, such as true, false, 1, or 0. |
isBatchManaged | Boolean, such as true, false, 1, or 0. |
trackingProfile | Non-empty text value. |
Import Process
Section titled “Import Process”- Go to Extensions > Improved Import, Export > Import.
- Create a new import profile.
- Select Pickware Product Stock as the entity.
- Choose your file source, such as upload, FTP/SFTP, URL, Google Drive, or Google Sheets.
- Map your file columns to Pickware Product Stock fields.
- Preview the import.
- Run the import.
Example CSV
Section titled “Example CSV”productNumber,reorderPoint,targetMaximumQuantity,isStockManagementDisabled,trackingProfileSW10001,10,80,false,numberSW10002,5,40,false,number- Use
productNumberwhen possible. It is easier to read and maintain than the Shopware product ID. - Export Pickware Product Stock first if you need a template with the current field names and values.
- Keep boolean values consistent across the file. For example, use only
trueandfalse, or only1and0.