---
title: Import Pickware Product Stock
description: How to import Pickware Product Stock records into Shopware 6 with Improved Import, Export & Mass Actions.
---

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

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. |

:::caution
The import must contain either `productNumber` or `productId`. It must also contain at least one Pickware product stock field to update.
:::

## Import Process

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.

## Example CSV

```csv
productNumber,reorderPoint,targetMaximumQuantity,isStockManagementDisabled,trackingProfile
SW10001,10,80,false,number
SW10002,5,40,false,number
```

## Tips

- 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`.

## Related Guides

- [Import Overview](/import/overview/)
- [Configure Mapping](/import/mapping/)
- [Preview & Run Import](/import/preview-and-run/)
- [Export Pickware Product Stock](/entities/pickware-product-stock/export/overview/)