MySQL error 1054: Unknown column 'p.products_group_a_price' in 'field list'

This is the error im getting due to uploading a .CSV via easypopulate.

MySQL error 1054: Unknown column 'p.products_group_a_price' in 'field list'

i have been told i need to add the field into the zencart database.
since im new to programming/coding. I need help on what to add in the newly added field.

picture is provided below.

What version of ZenCart
What version mysql
What version php
What version easypopulate

zen cart version : 1.3.9h
Pretty sure easy populate version : 1.3.9.gp
PHP version 5.2.14
MySQL version 5.1.51

try help me out kobra :)

finally fixed all done by myself due to zencart forums being terrible with replys... i relised i downloaded a easy populate group price edition.. noticing this i went in my zencart database and clicked on group pricing only to see " group_a_price " was missing. i soon added this to the database with group a,b,c,d being added. This fixed the issue.

Sorry it was a weekend :D

Hi i have same issue, i need to add

Zencart version is: 1.3.7 not updated due to a script i using for automatic import

products_group_a_price
products_group_b_price
products_group_c_price
products_group_d_price

just wondered what would the database look like for these fields please

Regards,
Aaron

Hi

I have the exact same problem but no idea what or how to add in the database table. Can anyone point me in the right direction please?

:dontgetit

this is my full error message

1054 Unknown column 'p.products_group_a_price' in 'field list'
in:
[select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_tax_class_id, p.products_group_a_price, p.products_group_b_price, p.products_group_c_price, p.products_group_d_price, p.products_quantity_order_min, p.products_quantity_order_units, p.product_is_free, p.products_priced_by_attribute, p.products_discount_type, p.products_discount_type_from from products p, products_description pd where p.products_id = '107' and pd.products_id = p.products_id and pd.language_id = '1']