To achieve high-flying results managing your e-commerce, you need to update your store regularly by bringing PrestaShop new products to make your range of goods wider and at the same time track inventory of the existing entities to make sure that you have them in plenty.
To perform all the mentioned actions and update your merchandise in bulk, most often store owners refer to PrestaShop import products from .csv procedure either with Admin panel or any other tool. However, beside of inevitable advantages of this process, quite often online merchants face some issues performing it. In this article we will point you to the most common pitfalls that you may face while importing goods.
So, let’s go through most important aspects:
1. Check your column names in .csv file before import
Be sure that your file for uploading is in the required format. All the column names should be exactly the same as your tool for PrestaShop import products from .csv requires. If they do not fit, you might need to do some modifications in your file.
In case you do not want to adjust your file or you want to automate an upload of new goods, the manual update is not an option. You can use the solution that allows you to map data on the fly. Store Manager for PrestaShop is exactly the one delivering such possibility. For example, if you have ‘recommended price’ in your file, you are to import the values into product price field without renaming it in .csv file.. Besides, this tool enables performing import from various file formats including .csv, .xml, .xls, .xlsx, .txt and .ods.
2. Check Images format that you have in your file
The same is true for PrestaShop images you are uploading. The required format for images is high-priority thing if you want to avoid ‘Image is not available’ message instead of actual product picture. They should be placed in a certain folder and correct names are specified.
One more thing you may encounter is often import tools do not allow you import PrestaShop images if they are stored somewhere remotely. So for mentioned purpose Store Manager comes in handy as it uploads both good local as well as remote images like http://supplier.site/images/imagename123.jpg.
3. Look at categories
Proper category tree makes the navigation of your customers at your store easier, since they can switch between the categories instead of mindlessly browsing through PrestaShop product list looking for needed products. So pay special attention to your categories. Smartly organize parent categories and sub-categories, assign items to them.
Built category tree of necessary structure with correct products assigned on the fly via Store Manager import tool. If you have any rules basing on which your categories should be built, you can apply them while import without any additional work with file before import or with products after.
4. Missing data
As you may already know performing PrestaShop import products from .csv you need to provide in the file full product information along with the data about which neither you nor your supplier didn’t even hear about. To avoid manual modifications of the .csv file, you can do some adjustments right in the process of import, sure thing, in case you do it using Store Manager. Basically, you can set default values for some fields, merge columns, change information in the columns easily and without manual intervention into the process. As an example we have in stock value that your supplier cannot provide you in the file, and you fill it while import with ‘1’ that is equal to “in stock” status.
Updating your existing PrestaShop products list be sure that you modify the products which you already have at your store instead of adding them again or you will have product duplicates. Using Store Manager for PrestaShop you yourself chose the purpose of import, so you can freely and without any hesitations at the same time upload information on new products as well as modify existing products’ data.
6. Necessity to import all data even if one field should be updated
Keeping an eye on your store inventory you definitely will have to update only a piece of the info, lets say stock level. Basically, you need to make changes only to one column, but most of import tools you might use, require a range of other columns without which import simply won’t go. But not in case of using Store Manager, as it requires only column for identification and columns you what to bring changes to.
7. Save settings for future
Think that you import once and you won’t need to do it further? Not even a close. The key of success if to do regular catalog modifications, adding new items and updating products list, uploading images. So probably having import configuration saved and using it for further imports, it exactly what is needed. You can save as many configurations as you have unique tasks or suppliers to be imported from with no additional fee.
Actually, its up to you to decide which exactly import tool and import method to chose. But as you read above the default import methods may not always bring you expected results. If you are searching for additional or improved import functionality, download Store Manager for PrestaShop and you’ll feel the difference.
How to Import Multiple Images to PrestaShop Products
Get step-by-step instructions on how to configure import file to upload a few images to one product. Read More…