In order to perform PrestaShop import procedure you need to have a spreadsheet containing 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. In order to make sure that the spreadsheet contains no mistakes and includes all the required information, you can download a file sample.
Where to Get the PrestaShop Import File Sample?
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 quantity of existing goods. Thus, supplier is commonly-used source of getting spreadsheets with information for import.
To adjust fields in a .csv and make it acceptable for import, you can compare it to PrestaShop import file sample offered by admin for download. You can, respectively, use it as reference when getting ready with your upload spreadsheet.
- As you have noticed, the platform offers .csv example for each of entities that can be uploaded. Another important thing is that categories and combinations are not imported together with products. You have to run the process again to upload these entities.
- Admin import tool accepts spreadsheets of .csv format only.
Import products FREE from XML, XLS/XLSX, ODS, TXT, CSV Import Now
What Columns Should Be included in PrestaShop Import File?
On PrestaShop import page you can find all the fields available in your import .csv, on the right side of this page.
PrestaShop does not require all these fields to be present in 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 (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;
- 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 the products you are going to upload;
- 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 much time on adjusting the import spreadsheet, 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 upload without additional modifications done. What’s more, in case you forgot to include some important details, it is possible to add them 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 format – 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