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.
Chunk product import from CSV
1: Generate an Access Token
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.
2: Download the CSV product import script
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`.
3: Create your source CSV file
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:
4: Run the product import
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.