Import osCommerce Data
IMPORT OSCOMMERCE DATA TO QINVOICING
This process is used to import the data from shops already in operation to the QINVOICING management software files .
If you are starting with a new shop, you will not need this process. You will only need to enter the products and categories in QINVOICING and run the Upgrade Shop process to fill in with the invoicing program data.
Before importing the data, you must enter the osCommerce integration settings and check that the connection test works, otherwise the import will not work.
This process will download the category, manufacturer and product data existing in the shop to QINVOICING, adding it to the invoicing files, as long as they do not exist in QINVOICING under the same code . Existing manufacturers and categories will not be used (no additions or changes to the existing one). Only fields marked for overwrite will be updated in existing products.
The data import program will use the codes for manufacturers, categories and products existing in osCommerce. Categories and manufacturers will be coded using the osCommerce internal numeric code.
In QINVOICING, the category code field is 5-digit number (99999). osCommerce assigns the internal category codes sequentially and therefore, this figure can never be exceeded. However, in some osCommerce contributions, the category codes are established according to the category structure. The import cannot be done without first changing these category codes to values below 99999.
For products with an alphanumeric QINVOICING code, the import program will use the osCommerce internal code, filling it with zeros up to a total of 5 positions. Example: 00001, 00020, 00034, etc.
The import process searches the QINVOICING category file (categories) by category code. If it does not exist, then the program will add the category. If it exists, nothing will be done (it will not update). The same approach is taken with manufacturers.
In the case of products, the program operation will depend on what is indicated in the Overwrite section if it already exists: These are added only if they do not exist. If the product already exists in QINVOICING, it updates only the fields indicated in this section. The model and manufacturer fields did not exist in versions earlier than ver. 9. If you have a previous version, you can download these fields to QINVOICING by doing an import with these two fields checked.
Existing inventory in osCommerce can be downloaded as the initial inventory in QINVOICING (only for products that no longer exist in QINVOICING). If the Import Inventory box is enabled, then the initial inventory records will be generated in the warehouse operation file with the description: INITIAL OSCOMMERCE INVENTORY on the import date and warehouse = 0 (main warehouse).
The program will download the photos of shop products, placing them in the QINVOICING photo folder for the company data. If you prefer to enter them by hand in this folder, check the box Do Not Download Photos box and put them in the folder indicated manually.
The Remember Parameters button uses these values, as well as to display them by default whenever the process is run.
Long descriptions with HTML or RTF editors
WARNING! If an HTML or RTF editor is installed to edit long product descriptions, these descriptions cannot be imported.
QINVOICING accepts plain text and html tags in long product descriptions, but not certain control codes used by these editors and therefore errors may occur when importing the data.
To solve this, go to Settings and uncheck the box for Transfer Long Product Descriptions before importing the osCommerce data.
Changes in long descriptions must be made by the shop manager using the editor installed. The Update program for the shop will not transfer the long descriptions and will keep the existing ones. QINVOICING Product Maintenance (Files --> Products) contains a button that directly opens the edit function for the osCommerce product , allowing you to easily update data not exist in the invoicing program.
Press the Import Data button to start the import
The process may take several minutes, depending on the number of products existing in the shop. The data import generates a log with notes on everything it does, along with the incidents that occur throughout the process. Once the process is finished, the log can be examined, saved and printed to review any incidents .
Once the process is finished, close the Log display and press the Exit button. In Files --> Products, Files --> Groups --> Categories and Files --> Manufacturers, check the data imported.
Normally, this process is only run at the beginning. Therefore, once it is done, you can disable it by denying access to the process for all user groups. This will prevent it from being used accidentally (see all information related to users, permissions and user groups in the QINVOICING manual or help).
Problems during import
The most common problems are related to wrong settings:
Connection problems : Refer to the most common connection errors in the section osCommerce integration settings.
Product names and descriptions are downloaded blank : This occurs because the match between the QINVOICING and the osCommerce languages was not correctly set up. To see the language codes that osCommerce has, use the Settings Report button on the General tab osCommerce integration settings to view the language codes and tax codes.
When entering the product record, the program gives a Tax Class Not Found error. Make sure that the tax class exists in the Tax Class file. Check the match between the QINVOICING and osCommerce tax classes. To see the language codes that osCommerce has, use the Settings Report button on the General tab osCommerce integration settingsto view the language codes and tax codes.
osCommerce Integration Settings