All Collections
POS Integrations
National Soft: Export and Import Product Catalogs
National Soft: Export and Import Product Catalogs
Sam Fielding avatar
Written by Sam Fielding
Updated over a week ago

If you are a multi-location user of National Soft and Soft Restaurant, you know that products are not shared through one POS master location. You can, however, export and import product catalogs from one location to another so that item PLUs don't have to be written manually on every location.

Follow these steps to export and import your POS product catalogs.

If you require assistance or have questions about this process, raise a support ticket with National Soft, as only they are best equipped to help you with these POS settings and behaviors.

Step 1. Generate a database backup

In Soft Restaurant, select Maintenance, Database, and then Database Backup.


Select the Backup button.

Step 2. Export the products catalog

In Soft Restaurant, select Maintenance, Export/Import Data, Catalogs, and then Export.


Select the Products option and then the Export button.

Step 3. Import the product catalog

For this process, it's necessary to do the following:

  1. Deactivate online sales

  2. Import catalogs

  3. Reactivate online sales

1. Deactivate online sales

In Soft Restaurant, select Maintenance, Tools for Managers, and then Execute command system.


Enter the following command:

abresql(rutaini,"dbsoftrestaurant")

Select the Execute button.

Now enter this command:

ejecutasql("UPDATE parametros3 SET ventasOnline=0")

Select the Execute button again.

2. Import catalogs

In Soft Restaurant, select Maintenance, Export/Import Data, Catalogs, and then Import.


Select the Search button and choose your ZIP file. Select the Import button.

3. Reactivate online sales

In Soft Restaurant, select Maintenance, Tools for Managers, and then Execute command system.


Enter the following command:

abresql(rutaini,"dbsoftrestaurant")

Select the Execute button.

Now enter this command:

ejecutasql("UPDATE parametros3 SET ventasOnline=1")

Select the Execute button again.

Did this answer your question?