Nov 20, 2012
Adrian Tubbs
wrote
Hi.
I have added several attribute groups, and a large number of attribute values in store manager, and all seems fine at first look. groups are there and values are listed in prestashop 1.5.2 and it looks like everything was posted to the live database ok.
Yhe problem starts when i went to add a product with combimations. the groups were not showing up in prestashop, add combinations screen. i imported a product with combinations from store manager, and the combination selections were not showing up on the product page.
i have checked that the attribute values exist, and are specified for the product.
i then noticed that the values count for attribute values in the prestashop BO (catalog>attributes and values) was showing 0 for the groups that i added with store manager, even though the values were listed.
if i edit one of the values and save it, the value count rises by one, and the attribute is available for use.
looking at the database tables, ps_attribute holds colour information, and unused fields are blank when added via prestashop, but unused fields are set to NULL if attributes are added via store manager. i think this is causing the problem.
i have tried editing the table to set the field to blank instead of null, but this is still not letting the atributes show in prestashops value count.
is there something else that prestashop does when saving the values for the attributes that i need to do to get prestashop to recognise the direct editing of the database.
this is driving me nuts, and i dont think its the only thing that it happens with as i did notice that several settings that i had in the CSV file were showing in store manager, but not prestashop.
Many thanks
Adrian
I have added several attribute groups, and a large number of attribute values in store manager, and all seems fine at first look. groups are there and values are listed in prestashop 1.5.2 and it looks like everything was posted to the live database ok.
Yhe problem starts when i went to add a product with combimations. the groups were not showing up in prestashop, add combinations screen. i imported a product with combinations from store manager, and the combination selections were not showing up on the product page.
i have checked that the attribute values exist, and are specified for the product.
i then noticed that the values count for attribute values in the prestashop BO (catalog>attributes and values) was showing 0 for the groups that i added with store manager, even though the values were listed.
if i edit one of the values and save it, the value count rises by one, and the attribute is available for use.
looking at the database tables, ps_attribute holds colour information, and unused fields are blank when added via prestashop, but unused fields are set to NULL if attributes are added via store manager. i think this is causing the problem.
i have tried editing the table to set the field to blank instead of null, but this is still not letting the atributes show in prestashops value count.
is there something else that prestashop does when saving the values for the attributes that i need to do to get prestashop to recognise the direct editing of the database.
this is driving me nuts, and i dont think its the only thing that it happens with as i did notice that several settings that i had in the CSV file were showing in store manager, but not prestashop.
Many thanks
Adrian
Reply
9 Answers
Nov 21, 2012
Dmytro Grycelyak
agent
wrote
Hello Adrian,
Thank you for your post.
Please submit a ticket here: http://support.emagicone.com/submit_ticket and provide us with the following: - your .csv file;
- import configuration file (may be saved at the last step of Import/Export Wizard);
- store configuration file (you can save you store configuration file at: Store Manager > Preferences(F12) > Database Connection tab > Store Configuration section > Actions... > Save current configuration: http://screencast.com/t/Hmy0nUDBsHJc)
We're looking forward to hearing from you.
Thank you for your post.
Please submit a ticket here: http://support.emagicone.com/submit_ticket and provide us with the following: - your .csv file;
- import configuration file (may be saved at the last step of Import/Export Wizard);
- store configuration file (you can save you store configuration file at: Store Manager > Preferences(F12) > Database Connection tab > Store Configuration section > Actions... > Save current configuration: http://screencast.com/t/Hmy0nUDBsHJc)
We're looking forward to hearing from you.
Nov 21, 2012
Adrian Tubbs
wrote
hi.
thanks for the reply.
i wasnt using a CSV file.
the attribute values were all added via the main screen in prestashop manager using either add attribute value or quick add attribute values buttons.
i have tried using all 3 connection methods with the add attribute and quick add attribute buttons, (bridge, tunnel, and direct database access). the results have been the same in each case.
looking at the sql script that updates the ps_attributes table (custom sql & raw table editing), if there is no colour information to insert into the table, it is set to insert NULL.
if you require config files and settings please just let me know, but i dont have CSV files that i can send as i didnt use them.
I am doing a import of products at the moment, and im using tunnel mode, as bridge mode kept giving a duplicate entry error (i know there are no duplicates in the csv file), so the pc will be busy for the next 10 hours or so.
many thanks.
thanks for the reply.
i wasnt using a CSV file.
the attribute values were all added via the main screen in prestashop manager using either add attribute value or quick add attribute values buttons.
i have tried using all 3 connection methods with the add attribute and quick add attribute buttons, (bridge, tunnel, and direct database access). the results have been the same in each case.
looking at the sql script that updates the ps_attributes table (custom sql & raw table editing), if there is no colour information to insert into the table, it is set to insert NULL.
if you require config files and settings please just let me know, but i dont have CSV files that i can send as i didnt use them.
I am doing a import of products at the moment, and im using tunnel mode, as bridge mode kept giving a duplicate entry error (i know there are no duplicates in the csv file), so the pc will be busy for the next 10 hours or so.
many thanks.
Nov 21, 2012
Adrian Tubbs
wrote
sorry,
the csv file that i referred to in the original post was a test import of products, and is totally separate from the attribute values problem. if it is a bug (with the product import) i will raise this as a separate issue. it was mentioned in the original post ti let you know that there may be other problems with the insertion of null values in tables.
the csv file that i referred to in the original post was a test import of products, and is totally separate from the attribute values problem. if it is a bug (with the product import) i will raise this as a separate issue. it was mentioned in the original post ti let you know that there may be other problems with the insertion of null values in tables.
Nov 22, 2012
Dmytro Grycelyak
agent
wrote
Hello!
Thank you for keeping us informed.
Yes, please submit a ticket and provide us with your store configuration file, so we could check the issue with attribute groups and values for you.
Concerning the Duplicated Entry error. This error indicates that Store Manager can not Post Changes to Web because some data may be duplicated.
Probably you have being doing some changes from PrestaShop back-end while making changes in Store Manager.
In order to fix the issue, please perform Get Data from Web (in order to synchronize the Store Manger with the actual data of your database), make changes once more and Post Changes to Web.
Thank you for keeping us informed.
Yes, please submit a ticket and provide us with your store configuration file, so we could check the issue with attribute groups and values for you.
Concerning the Duplicated Entry error. This error indicates that Store Manager can not Post Changes to Web because some data may be duplicated.
Probably you have being doing some changes from PrestaShop back-end while making changes in Store Manager.
In order to fix the issue, please perform Get Data from Web (in order to synchronize the Store Manger with the actual data of your database), make changes once more and Post Changes to Web.
Nov 23, 2012
Adrian Tubbs
wrote
thanks Volodymyr.
that worked. for some reason the upload didnt complete the first time and i tried to run it again. thats what caused the problem. all sorted now.
have sent off the support ticket and files as requested.
there are other things that i have noticed, such as the Attribute Available Date
field defaulting to todays date when left blank/not specified in a csv import. do you want me to post them here, or start a new topic for each one?.
many thanks for your help.
that worked. for some reason the upload didnt complete the first time and i tried to run it again. thats what caused the problem. all sorted now.
have sent off the support ticket and files as requested.
there are other things that i have noticed, such as the Attribute Available Date
field defaulting to todays date when left blank/not specified in a csv import. do you want me to post them here, or start a new topic for each one?.
many thanks for your help.
Nov 25, 2012
Adrian Tubbs
wrote
ok, so i think i have found the answer.
when you add attribute values to a attribute group, it is assigned a attribute number (incremented automatically) and the relevant data is inserted into the tables ps_attribute, ps_attribute_lang, but there is no entry being made into ps_attribute_shop.
this means that prestashop cannot find the data for the attributes that belong to the attribute groups for shop 1, as they have not yet been assigned to a shop.
i cant verify that this is what is happening as my trial time has expired, but when my shop has made some money i will be getting your product as i can directly edit the table to fix this. i will then look at some of the other problems i have found.
hope this helps.
all the best.
Adrian
when you add attribute values to a attribute group, it is assigned a attribute number (incremented automatically) and the relevant data is inserted into the tables ps_attribute, ps_attribute_lang, but there is no entry being made into ps_attribute_shop.
this means that prestashop cannot find the data for the attributes that belong to the attribute groups for shop 1, as they have not yet been assigned to a shop.
i cant verify that this is what is happening as my trial time has expired, but when my shop has made some money i will be getting your product as i can directly edit the table to fix this. i will then look at some of the other problems i have found.
hope this helps.
all the best.
Adrian
Nov 26, 2012
Dmytro Grycelyak
agent
wrote
Hello Adrian!
Thank you for your messages.
Actually we have fixed the issue with attributes generation and now Store Manager populates 'attribute_shop' table as well.
Please make sure that you have associated your attributes with the exact stores: http://screencast.com/t/Z5J4QbZZou8
By the way, we have extended your trial license for 2 weeks so your could continue using the Store Manager ;)
You can find your license key and download the application from your license account at: http://license.emagicone.com
Thank you for your messages.
Actually we have fixed the issue with attributes generation and now Store Manager populates 'attribute_shop' table as well.
Please make sure that you have associated your attributes with the exact stores: http://screencast.com/t/Z5J4QbZZou8
By the way, we have extended your trial license for 2 weeks so your could continue using the Store Manager ;)
You can find your license key and download the application from your license account at: http://license.emagicone.com
Nov 26, 2012
Adrian Tubbs
wrote
Thank you for that Volodymyr. i have looked at the licence page (License #99240) but it says expired still, and when i go to the main website page and run the installer it says trial period expired. once i can install the latest software i will try to get precice details of the issues i have found and let you know.
Again, many thanks for your help.
adrain.
Again, many thanks for your help.
adrain.
Nov 27, 2012
Dmytro Grycelyak
agent
wrote
Hello Adrian!
I'm sorry, my bad. Please check once more.
I'm sorry, my bad. Please check once more.