CSV Product Import into PIM

The core of PIM is products and product information. The base product information is often created initially in an ERP system like SAP or ERPNext, then imported to your PIM. You can manually create the product information in Crystallize or; when working with large product sets that frequently update create an automatic import and update integration. We have made an open-source CSV product import for Crystallize to get you started.

The CSV product import tool will help you speed up your development process as it will allow developers to use a JavaScript script to import all products. You just need to have a CSV file and your Crystallize Access Token then the script imports your products via the PIM API.

First, you need an access token id and secret. That can be obtained on your Crystallize account under settings.

Give your token a name and click generate. A new token is displayed once in a popup. Save it securely as Crystallize will never show it to you again. You know, security.

Second, head over to our repository and clone or download the csv product import script.

After the download is completed, go to folder `product-import-from-csv` and install the dependencies `npm install` or `yarn install`.

Create a CSV file by e.g. exporting from your ERP system. The structure of the CSV file needs to match so products can be correctly imported into your product catalogue. For your products CSV file structure should be:

• id 
• type
• sku 
• name 
• price 
• attributes
• stock

Start the script, `npm start` or `yarn start`, and follow the command-line instructions.

The script will identify how many products you have in your CSV file.

You need to know your tenant id, that can be found also under settings.

Then enter your token id and secret.

If everything goes as expected, when the script finishes, you should see a successful message and a list of the imported products.

And that’s it, you should be able to see your newly imported products in your catalogue.

After this, you will be one step closer to have your fast eCommerce website ready for your customers.

Have any questions or suggestions about the product import, you can reach us through the contact form at crystallize.com/about or create an issue in the product import GitHub repository we’ll be glad to help.