Documentation: XML to OpenCart Script

Overview

This script facilitates importing product data from an XML file into an OpenCart website, including the handling of categories and products. It ensures data synchronization by adding new items, updating existing ones, and removing outdated entries.

Steps to Run the Script

1. Download the latest XML by running the following link:
   https://www.impamark-promotional-merchandise.co.uk/webupdater/public/index.php?action=download_supplier_one

   The page will display a message indicating the download completion.

2. Run the script to import and process the XML:
   https://www.impamark-promotional-merchandise.co.uk/webupdater/public/index.php?action=import_supplier_one

   During this process, you'll see a table allowing you to assign new categories under parent categories. Once completed, the script proceeds automatically until it displays:

   "All processes are completed successfully."

Full Reset / Scratch Process

A new action has been added to completely reset the database and start fresh. This is useful for development or when a full re-import is required.

What it does:

• Truncates Database Tables: Deletes all products, categories, option values, and related data from the OpenCart database. It resets auto-increment counters so IDs start from 1.
• Clears Local Cache: Deletes Product-Sku.csv, Category-Cache.csv, Product-Options.csv, and access_token.json to ensure a clean state.
• Recreates Main Categories: Automatically creates the main categories (IDs 1-11) based on Category-Website-Descriptions.csv.
• Starts Import: Automatically triggers the standard import process after the reset.

How to run:

Configuration Requirements:

To use this feature, you must add the database connection details to your .env file:

WARNING: This action is destructive! It will delete all product and category data. Ensure you have a backup before running this on a live environment.

Important Notes for OpenCart

• Products and subcategories imported from the XML (Advantage) should not be deleted manually, as the script relies on cached IDs.
• Custom categories outside parent categories are safe from deletion and can be created or edited freely.
• To protect custom products, enter 'notdelete' in the 'Location' field during product creation.
• For Excel Sheet import we have left some free IDs. For categories we have IDs from 12-100 free (main categories from 1-11) and for products we have IDs from 0-999.