> For the complete documentation index, see [llms.txt](https://wiki.orderlion.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://wiki.orderlion.com/resources-for-wholesalers/import-wizard.md).

# Import Wizard

Basis: A file containing product information in Excel or CSV format. This template can be downloaded in Step 3 or exported from the ERP.

**What information should my file contain?**

* Product number
* Product name
* Order units
* Price

**Here's how:**

Start by clicking on Import Assistant in the Article tab in the top right corner.

<figure><img src="/files/cgoN6bVBCvXNyoS9sSLH" alt=""><figcaption></figcaption></figure>

**1) Scope:** For whom do you want to make changes?

Define whether the imported products affect all customers or a specific assortment.

<figure><img src="/files/5O5g9lGoENjzbVRaX29j" alt=""><figcaption></figcaption></figure>

**2) Changes:** What would you like to change?&#x20;

Decide whether you want to create or edit an assortment, or just update prices. For price adjustments, products not part of the import remain untouched. For assortment changes, the standard assortment is updated, limiting the products a customer can order, and new products are added.

<figure><img src="/files/Wpl1meSRMJM3Mky9atJL" alt=""><figcaption></figcaption></figure>

**3) Upload a product information file**

Upload a file with product information. You can also find an Excel file as a template for editing under "Download product list of Standard Product Range."

<figure><img src="/files/Ev2YqhjEJjRDVkVlDLST" alt=""><figcaption></figcaption></figure>

**4) Define columns:**&#x20;

Assign the correct definition to the columns. This step is skipped if the Orderlion template is used, but it is recommended to go back and review it.

<figure><img src="/files/ykGuwmnyX0T4Bd5wtxId" alt=""><figcaption></figcaption></figure>

**5) Update method:**&#x20;

What should happen to products that are part of the assortment but not included in this import? Choose how to handle products that are part of the assortment but not included in the current import. You can choose whether missing products should be kept or deactivated in the assortment.

* Keep: Products not part of the import remain active. No products or prices are deactivated or deleted.
* Disable: Products and prices not included in the current import are disabled.

<figure><img src="/files/QpVB5bil9RoV3zHClAMy" alt=""><figcaption></figcaption></figure>

**6) or 5) Products preview:**&#x20;

Check the preview of your assortment in the webshop. Press "Read Files" to complete the import.

<figure><img src="/files/nlA11YG54JBsLreloDL5" alt=""><figcaption></figcaption></figure>

Click "Read Files" to complete the import.

<figure><img src="/files/Hfcv8h9VIgdXmerO4TJa" alt=""><figcaption></figcaption></figure>

Success!