How to Upload Excel Files to PrestaShop?

The most widespread model of PrestaShop import is data upload from files of csv format. Although very often online merchants come across Excel files, for example, receive them from wholesalers, what requires additional amendments carrying out. Before uploads you should convert Excel files to .csv ones what might be rather annoying and bring data structure violation at times.

Store Manager for PrestaShop steps over import limitations, confirming import from Excel to PrestaShop via built-in tool called import wizard. It endows you with more opportunities to run data upload swimmingly and makes catalog handling more approachable.

PrestaShop Excel file upload scheme presents no difficulties as it’s quite similar to data upload from .csv files accomplishment. It’s recommended to diligently view the file before data appending to ascertain that needed information on PrestaShop entities is incorporated and accurate values are given.

Points to Consider Before Starting Import to PrestaShop from Excel

• Store Manager program is equipped with database backup functionality. You have an opportunity to carry out backup and save information to the file on your PC. If some import mishaps occur, you can resort to data recovery.


• With Store Manager application you won’t be nonplused with mass images upload – it’s easy to upload local and remote images during import from Excel to PrestaShop. Image upload requires FTP connection to be set, in ‘Preferences’ (F12) window of Store Manager application.


• Executing PrestaShop import from Excel file, you can use saved formerly configuration not to spend time for reconfiguring and just to click “Next” option to fulfil the process.


• Thanks to import options, offered at one of data appending steps, you can carry out different operations over data: renew your catalog, only upload new entities to it, just add products or update store content and append new products to database simultaneously.

To PrestaShop from Excel: Data Upload Instructions

1. The wizard have been launched and Excel file chosen, you are to carefully read wizard instructions and be guided by hints given in each and every window to successfully upload the file.





Important:

In order to import xls files with Store Manager, Microsoft Access Database Engine is required. If you do not have it installed, Store Manager shows a message and offers to install the processor.





*Microsoft Access Database Engine is a set of components that facilitate the transfer of data between existing Microsoft Office files such as Microsoft Office Excel 2010 (*.xls, *.xlsx, and *.xlsb) files to other data sources such as Microsoft SQL Server.



2. Preview feed data in corresponding wizard window to make sure records are arranged in a suitable manner and will further be successfully imported to PrestaShop.


If there are several spreadsheets in the .xls file, you should select the one data will be imported from, since one spreadsheet can be imported at a time.




3. Check data at preview step, select multiple value delimiter set category import options (you can use category ID for identification and keep current category associations selecting corresponding option)




If images should be added in the process of PrestaShop Excel import enable ‘Import Images’ checkbox and specify path to local folder storing images, if local ones are being added. The same concerns downloadable products, if there are some in the import file, enable ‘Import downloadable file for virtual products’ option and indicate local folder, from which they will be taken.


4. PrestaShop Excel import effectiveness depends on accurateness of file columns and database fields linking. Choose correct product identifier depending on that, indicated in Excel file.




5. Indicate correct PrestaShop Excel import options in this field. It’s possible to save current import configuration at this step and use it for future import procedures.




6. View results in the last wizard window.

The possibility to undertake Excel files upload to PrestaShop at ease brings new perspectives to online shopkeepers and helps create relevant PrestaShop catalog.