Performing PrestaShop import procedure you need to have spreadsheet with information that will be used for bringing in new data or updating existing entities at your web shop. The first and one of the most important steps in this process is either getting or generating the file for massive PrestaShop import from .csv or other format supported. You have to make sure that spreadsheet is suitable for upload (no error will be returned) and at the same time it includes all the required information.
Where to Get the File for PrestaShop Import?
Usually shop owners do not have goods stored in their local warehouses, but they are placed somewhere remotely and online merchant only receives information on new products available on the market or changes of stock and quantity of existing goods. Thus, supplier is commonly-used source of getting spreadsheets with information for import.
To adjust fields in .csv file and make it acceptable by PrestaShop import tool, you may always rely on .csv file sample, PrestaShop admin offers for download. You can, respectively, use it as reference when getting ready with your import spreadsheet.
- As you have noticed, PrestaShop offers import file model for each of entities that can be uploaded. Another important thing is that, categories and combinations are not imported together with products. You should run separate import to upload these entities.
- Admin import tool accepts files of .csv format only.
Import products FREE from any file type – XML, XLS/XLSX, ODS, TXT, CSV Import Now
What Columns Should Be in PrestaShop Import CSV File?
When you access PrestaShop import page, you will see all the fields, you can have in your import file, on the right side of this page.
PrestaShop does not require all these fields to be available in .csv import spreadsheet. Though to create fully-fledged listings, make sure file contains:
- Name – product name itself;
- Active – set 1 for products if they should be active, contrariwise provide 0 in this field;
- Categories – category, product should be added to;
- Price – indicate tax included or tax excluded product price;
- Tax ID – provide ID of tax rule if you need to associate some with product;
- Reference # – add product reference. Reference is defined as code used for inventory tracking. This internal number is usually called stock keeping unit, but PrestaShop calls it Reference;
- Supplier reference # – associate supplier reference with merchandise providing it in corresponding column of your .csv file;
- Supplier – assign supplier to products, indicating it in this column;
- Manufacturer – add product manufacturer;
- Weight – product weight;
- Quantity – number of products you have in stock;
- Minimal quantity – configure how many items of this or that product should customer add to cart for order to be accepted;
- Visibility – define whether products should be shown in catalog, search, both or none of these options;
- Short description – provide some details about PrestaShop products you are going to import;
- Description – specify complete product description so your customers will get maximum details;
- Meta Information (Meta Title, Meta Description) – add these details since they are important for SEO;
- Available for order – to enable product sale add 1 in this field, contrariwise – 0 value;
- Image URL – to create representative product page, you have to upload its image. Input image URL for each record;
- Condition – configure product condition – new, used, refurbished;
- Out of Stock – enable or disable products you import, adding 0 and 1 in this field correspondingly.
Some fields in the list are responsible for product representation at the frontend, the other help describe products. You can, of course, include other details, depending on your purpose, for example make product downloadable, configure dimensions (height, width), assign discount and so on.
How to Make PrestaShop Import from .CSV More Approachable?
If you do not want to waste too many hours on adjusting the file for PrestaShop import, you might reveal for yourself alternative tools to handle the process. For instance, Store Manager for PrestaShop application allows you to upload files of basically any structure and in multiple formats – .csv, .xml, .xls, .txt, .ods. This way, no matter if you create file yourself or get the one from supplier, you can right away use it for import without additional modifications done. What’s more, in case you forgot to include some important details, it is possible to add then right in the process of upload without returning to file itself.
It should be indicated that performing PrestaShop import with Store Manager, you can create new categories on the fly, assign combinations and features, having them in the same import file. Store Manager import wizard uploads data stored in any file type – CSV, XML, XLS/XLSX, ODS, TXT, what means you shouldn’t bother about file converting. Follow the link to find out more about Store Manager for PrestaShop import capabilities – Import Products to PrestaShop using Store Manager