Reset Replication Data

This is an essential feature designed for development. It can simplify the development process and can increase the efficiency in testing and replicating data.

Replication is a two-way process: 

  1. In the first step you get data from Commerce and store the data in the ls_* tables.
  2. In the second step Magento processes these data from the ls_* tables into Magento catalog tables.

The purpose of this feature is to provide an interface to reset data only for the required area that is needed to replicate or process again in Magento. This is divided into 7 categories:

Note: This functionality will only reset the data in Magento database and will not affect any data in LS Central database.

Delete Orders

This feature

  • deletes all orders created in Magento.
  • deletes all meta data of orders including invoices, shipment, and credit memos that are created in Magento.
  • does not delete any orders from LS Central.
  • is used when you must delete all dummy orders in Magento before going live.

Delete Customers

This feature

  • deletes all customers created in Magento and refreshes the customer counter in Magento.
  • removes all customer addresses and all other meta information about customers that are created in Magento.
  • does not delete any customer information from LS Central.
  • is used when you must delete all dummy customer data from Magento before going live.

Delete Products and set processed to false

This feature

  • deletes all products that are created in Magento, regardless of their type (simple, configurable, and so on).
  • removes all other meta information about products from Magento, including product attributes, variants, images, and inventory.
  • resets the flag of processed to 0 for all items in the ls_replication_repl_item tables.
  • does not remove any product data or meta data from LS Central.
  • only deletes data from Magento's catalog product tables and only resets the flag of the Processed column to 0 for all items in the ls_* tables.
  • is used when you want Magento to process the product data again from the ls_* tables.

Delete Categories and set processed to false

This feature

  • deletes all categories data that are created in Magento.
  • removes all other meta information about categories from Magento, including images and attributes.
  • does not remove any category data or meta data from LS Central.
  • only deletes data from Magento's catalog and category tables and only resets the flag of the Processed column to 0 for entries in the ls_* tables.
  • is used when you want Magento to process the category data again from ls_* tables.

Delete Attributes and set processed to false

This feature

  • deletes all attributes that are created in Magento.
  • removes all other meta information about attributes and variants from Magento, including attribute options, attribute options values, and variants images.
  • does not remove any attribute data or meta data from LS NAV/LS Central.
  • only deletes data from Magento's eav attribute tables and only resets the flag of the Processed column to 0 for entries in the ls_* tables.
  • is used when you want Magento to process the attributes, attribute options, or attribute option types again from the ls_* tables.

Delete Discounts and set processed to false

This feature

  • deletes all discount rules created in Magento.
  • removes all catalog rule data, discount rule data, discount values, and product conditions created in Magento.
  • does not remove any discount or promotion data from LS Central.
  • only deletes data from Magento's catalog rule tables and only resets the flag of the Processed column to 0 for entries in the ls_* tables.
  • is used when you want Magento to process the discount rules again from the ls_* tables.

Truncate all ls_tables

This feature

  • truncates all replication data with the prefix ls_* in Magento's database.
  • resets all replication jobs counters to 0, which causes replication of data from Commerce to start again.
  • is used when you want to get a complete fresh copy of data from LS Central to the ls_* tables in Magento's database.