仅导入magento类别和产品表 [英] Import magento category and product table only

问题描述

我们现在有两个magento应用程序.一个(APP A)具有类别和产品数据，这些数据将在另一个magento应用程序(APP B)中使用.

We now have two magento applications. One(APP A) has category and product data which will be used in another magento application(APP B).

由于APP B具有许多新设置，例如关键字，元描述等，因此我们不能直接使用APP A的数据库，而只能直接使用类别和产品表.

Because APP B has lots of new settings such as keywords, meta descriptions, etc, we can not directly use APP A's database but only category and product tables.

有没有一种方法可以将APP A的类别和产品数据库导入APP B?非常感谢你！

So is there a method to import category and product database of APP A to APP B? Thank you very much!

推荐答案

这是我的操作方式.我当时在根目录下的测试文件夹中建立了一家新商店，与此同时，生产过程中出现了销售，新产品/客户以及库存变化.

Here's how I did this. I was building a new store in a test folder off root, and in the meantime production had sales, new products/customers and also inventory changes obviously.

您还需要获取所有的mage_cataloginventory_stock表:

You also need to get all mage_cataloginventory_stock tables:

mage_cataloginventory_stock
mage_cataloginventory_stock_item
mage_cataloginventory_stock_status
mage_cataloginventory_stock_idx
mage_cataloginventory_stock_tmp

• 禁用编译器和缓存，清除缓存

除了以上答案中列出的正确的表外，删除我的表后(在拖放时禁用外键检查，从phpmyadmin截断不起作用)，这是要做的事

In addition to the tables listed in the above answer, which are correct, upon dropping my tables (disable foreign key checks at drop, truncate didn't work from phpmyadmin), here's what to do

• 导入数据
• 重新编制索引.

媒体(图像)与安装URL有关，因此，我将生产存储从根目录移到了子目录，一切都很好.

Media (images) are related to install URL, so, I was moving a production store in root directory to sub directory and all was fine.

先备份目标数据库.

这篇关于仅导入magento类别和产品表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！