|
I’m having a problem updating my product database. When I import the .csv using the profile “Import All Products” with ‘admin’ as the value of each product’s ‘store’ field, I get no errors on the import, but nothing in the database updates.
When I import the .csv using the profile “Import All Products” with ‘default’ as the value of each product’s ‘store’ field, again I get no errors, and this time everything updates except for the title and descriptions (short and long), which strangely seem to PARTIALLY update in the database. By partially, I mean the new title and descriptions are reflected on the front end of the website, and under Sales->Orders when adding products to an order from the backend. The old title and descriptions show up under Catalog->Manage Products.
I ran this sql query, and the results might help someone else understand what’s going on here:
SELECT * FROM `catalog_product_entity_varchar` WHERE `entity_id` =1;
+----------+----------------+--------------+----------+-----------+----------------------------------+
| value_id | entity_type_id | attribute_id | store_id | entity_id | value |
+----------+----------------+--------------+----------+-----------+----------------------------------+
| 1 | 4 | 55 | 0 | 1 | Anna (Tennessee) |
| 2 | 4 | 81 | 0 | 1 | anna-tennessee-ut-orange-0 |
| 3 | 4 | 437 | 0 | 1 | 2 |
| 6 | 4 | 69 | 0 | 1 | no_selection |
| 7 | 4 | 70 | 0 | 1 | no_selection |
| 8 | 4 | 71 | 0 | 1 | no_selection |
| 10 | 4 | 90 | 0 | 1 | container2 |
| 11 | 4 | 82 | 0 | 1 | anna-tennessee-ut-orange-0.php |
| 1386 | 4 | 66 | 0 | 1 | |
| 1387 | 4 | 68 | 0 | 1 | |
| 2385 | 4 | 91 | 0 | 1 | |
| 13444 | 4 | 451 | 0 | 1 | 75 |
| 26265 | 4 | 55 | 1 | 1 | Anna (Tennessee) - UT Orange - 0 |
+----------+----------------+--------------+----------+-----------+----------------------------------+
13 rows in set (0.00 sec)
You can see that the new title, Anna (Tennessee) - UT Orange - 0, has the same entity_type_id, attribute_id, and entity_id as the old title, Anna (Tennessee), except that it thinks it’s part of store_id 1. I changed all the values where store_id=1 to store_id=0, and it showed the most recently updated titles where it didn’t before, but it cause the backend to break under certain circumstances, so I restored a backup of the db.
Can anyone at least shed some light on this?
|
