Skip to content

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.

Prepare a file with one row per product stock record.

Include one of these product identifiers:

FieldUse
productNumberProduct number of the Shopware product. This is the recommended identifier for most imports.
productIdShopware product ID. Use this when your source system already stores Shopware IDs.

Then add the Pickware fields you want to update.

FieldExpected value
reorderPointInteger.
targetMaximumQuantityInteger.
isExcludedFromReorderNotificationMailBoolean, such as true, false, 1, or 0.
isStockManagementDisabledBoolean, such as true, false, 1, or 0.
shipAutomaticallyBoolean, such as true, false, 1, or 0.
isBatchManagedBoolean, such as true, false, 1, or 0.
trackingProfileNon-empty text value.
  1. Go to Extensions > Improved Import, Export > Import.
  2. Create a new import profile.
  3. Select Pickware Product Stock as the entity.
  4. Choose your file source, such as upload, FTP/SFTP, URL, Google Drive, or Google Sheets.
  5. Map your file columns to Pickware Product Stock fields.
  6. Preview the import.
  7. Run the import.
productNumber,reorderPoint,targetMaximumQuantity,isStockManagementDisabled,trackingProfile
SW10001,10,80,false,number
SW10002,5,40,false,number
  • Use productNumber when 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 true and false, or only 1 and 0.