Hello! I was trying to backup the products from another based to another. How do I backup the “related products” that I created for blocks?! Thank you!
The links for all the blocks are stored in the cscart_block_links table, but you will want to keep cscart_blocks, cscart_block_descriptions and this table in sync.
You can find the block_id you want by searching the ‘block’ field in cscart_block_descriptions (e.g., search block for “related” if your block is called “Related products”).
You can then use the block_id to search cscart_block_links. Product blocks will have a location of “products”. The object_id is the product and the item_ids is the linked product.
You should be able to export/import these tables using phpMyAdmin but if importing into an existing table, make sure the items above are matched up/accounted for prior to import.
Bob
ok. thanks for the direction and help.