1054 - Unknown column 'p.products_master' in 'fiel

[stewdawg35]

:blink: I uploaded a test set of data using easy populate and got this: What do I do?

 

1054 - Unknown column 'p.products_master' in 'field list'

 

SELECT p.products_id as v_products_id, p.products_model as v_products_model, p.products_image as v_products_image, p.products_price as v_products_price, p.products_weight as v_products_weight, p.products_master as v_products_master, p.products_master_status as v_products_master_status, p.products_listing_status as v_products_listing_status, p.products_date_added as v_date_avail, p.products_tax_class_id as v_tax_class_id, p.products_quantity as v_products_quantity, p.manufacturers_id as v_manufacturers_id, subc.categories_id as v_categories_id FROM products as p, categories as subc, products_to_categories as ptoc WHERE p.products_id = ptoc.products_id AND p.products_model = 'CDG-LC001' AND ptoc.categories_id = subc.categories_id

 

Thank you so much

[Guest]

That test data is for an installation running the Master Products contribution - where did you get it?

 

Matti

[stewdawg35]

The products I uploaded were just a sample from my entire store, I uploaded a text file to edit, saved it and edited it in excell. than I uploaded it to the database and got that response. Do I need to go into master products and make the variables the same as in my product file? If so where can I find masterproducts?

thanks for your help.

[Guest]

I believe that there is a Master Products/Easypopulate contribution - if you have used this without having Master Products installed then you will have problems - search contributions.

 

Matti