The inventory spreadsheet a client gave me has variable characters for category codes instead of integers, i.e. AC=Accessories
These are the changes I made to each of the following tables:
Categories
categories_id varchar(11) AC
parent_id varchar(11) AC
Categories_Description
categories_id varchar(11) AC
Products
master_categories_id varchar(11) AC
Products-to-Categories
categories_id varchar(11) AC
The categories are listed correctly in the categories box on the site. The products show in the different product areas such as new products. But, If i click on the Accessories category link, none of the products for the category show.
Also on the admin dashboard it's showing the 1303 product count, but no categories or products show in the admin catalog area.
What have I missed or is this even a viable way to be able to import inventory without having to set up some extreme excel mapping formulas crap??
Bookmarks