Yes it is possible to import a csv with PrestaShop. But if you read these lines, I imagine that like many others, you faced some if not all of the problems posed by this tool. I will mention only a few:
You will never encounter a time-out problem because the software optimizes in real time the size of the SQL queries sent to the server.
The record to date is a file of 360,000 product sheets imported at one time by a car parts seller.
For very large files, which can crash Windows, it is possible to ask the module to split the processing of the file in packets of lines (for example 8000).
The import speed is limited mainly by the server and the network and is proportional to the number of columns to process.
You have a classic shared server: the average time is 0.3s per line.
You have a dedicated server: the speed record, made every day by one of our customers on its dedicated server, is 0.04s per line. Only 7 minutes each night to automatically import or update prices and quantities of 10,000 new products.
You have the freedom to encrypt queries or not.
The addon script checks the import success of each line. You can export the import status report.
You decide which lines to import or not, which column to process or not. You can test safely on a few lines without having to modify the file.
Whether you have your own stock or sell by dropshipping, whether you have 100 or 50,000 products, whether you need to update your records every 2 hours or once a year for sales, Merlin Backoffice will be a success partner:
Do not worry anymore to understand the requested file format, there is none. The only rule: a file has to be organized in columns, with a unique title for each of them. You can choose your column titles, their order, their number. You can delete them , add some, ignore some ...
You got a non-standard .CSV file, with strange column separators, extra quotes ...? let Merlin Backoffice deal with that.
The data are located in the 5th sheet of an Excel file, from the 10th line? This is not a problem for this addon, just tell him where are the data to import.
No need to download the file from provider's server to your pc, the addon does it for you. He even knows how to choose the most recent file from several self-dated files.
To do so, other import modules will require you to create scripts, and to create cron jobs with them, after having installed a cron module that you will have to learn how to configure. This is too technical and a waste of your time...
Merlin Backoffice integrates its own simple and powerful planner, with which it is possible to plan in a few clicks an unlimited number of unique or repetitive events. With an unlimited choice of the frequency (every x minutes, hours, days, such day of the week or month, etc.) and saved filters.
In the early morning, you will just have to have a look at the detailed report of the night and can devote yourself to your business.
With the "Category Management" option, Merlin Backoffice is able from your product listing, containing the names of their default category, to create these if they do not exist yet. It can also import complete trees, with categories' descriptions and meta SEO fields.
The sales period is coming and your wholesaler has given you a file with the discounts to put in place in your shop, by tomorrow... Do not worry, Merlin Backoffice replacement pluggin is able to download this data to your database in just a few clicks.
It can also processes a file containing several columns, each containing a volume discounted price for a certain amount purchased, for a specific customers group, location etc...
Finally a simple solution, particularly well suited to the classic files provided by dropshippers. To import the variants of products, you just need a basic file with one column per attribute group (size, color, ...).
Tired of buying an expensive module or a dedicated extension for each new dropshipper that you want to work with?
With Merlin Backoffice PrestaShop addon, you create as many feeds as you want, without any extra spending.
There are no user fees. The licenses are valid for life.
With over 90 items (columns) importable, it's the most comprehensive data transfer solution.
The process is linear and simple, in 5 steps: