Import/Export (CSV)

Now products from the admin panel can be exported to a simple and accessible format for all Excel-tables, as well as perform the opposite action - import from .csv files to the admin panel.

A module with which you can:

1. export - unload the catalog of goods from the store's database into csv format, while you can select a separator (for different localizations of Microsoft Excel), select the preset required fields for export, and also filter the selection by product category and / or manufacturer.
2. import - load the product catalog from the .csv file into the site database. At the same time, the system automatically updates existing products (by the identifier "code"), if necessary, adds new products, categories, manufacturers and attributes of goods, and also deletes products with the "delete" status.

This module is optimized and configured in such a way that with it you can upload tens of thousands of products with images to the site, even on servers with minimal technical support. characteristics.

When this module is needed:

Most often it is used when the store administrator has additional software, an application or a service that can upload a catalog in the form of csv / xls / xlsx tables and is the main tool for working with goods for a given store, and the online store itself must quickly synchronize with this the main base. Usually these are warehouse programs like Torgsoft, 1C, etc.

How the import / export module is used:

• during the initial upload of goods to the site;
• for constant and quick updating of prices, availability of goods and operational changes;
• to add new products and remove unnecessary ones;
• when unloading a catalog from the store for third-party applications.

Attention 1! When importing goods into the catalog, the "code" field (article of the goods) is the identifier of the goods, therefore it must be 1) mandatory 2) unique.

Attention 2! Never use this module as a migration - transferring data from one store to oscommerce (solomono) to a newer one, because alt="Import/Export (CSV) - 2" hough the import will be successful and all the goods will be transferred correctly, the IDs of the goods and categories will not be saved, which will cause irreparable damage to the SEO of the site, all the old pages will drop out of the search engine index and the re-indexing of the directory will begin.
For a complete migration from the old oscommerce version, we have a separate module "Migration" (https://solomono.net/ru/migracija-bazy-dannyh-oscommerce-/p-595.html)