Jump to content
raktrri

Product combination generator in admin panel not storing data in DB

Recommended Posts

1. Did it work before?

2. Generating combinations can be confusing as you need to push two buttons. So it would be interesting to know what exactly you did.

Share this post


Link to post
Share on other sites

@musicmaster

1. No i guess, after i upgrade it doesnt

2. I tried generating multiple combination by selecting attributes. After submit i got success message but data is not there. Please check the screenshot i shared

Share this post


Link to post
Share on other sites

My guess still is that you select the combinations but that you don't press the generate button. But you are so evasive in your answers that it is hard to find out. If you want a technical problem solved you should take the time to describe every button you clicked and every field you filled or checked. I know it is boring but if you don't like to do this boring stuff you are just wasting my (and other people's) time.

Share this post


Link to post
Share on other sites

@musicmaster

Steps that i followed to generate multiple combination

1. Go to product edit

2. click on the combination

3. clicked product combination generator.

4. then i select 2 colors from 1 group and 2 size from another group and clicked add

5. entered 6 quantity and reference

6. After that i clicked Generate these combination

7. it redirect me to the combination tab with success message but with no data

Share this post


Link to post
Share on other sites

ok, that looks better.

Next question: if I do so I see in top left corner: "Edit: productname". In your case I see "filter by ID: 809". What is happening there?

Share this post


Link to post
Share on other sites
5 hours ago, raktrri said:

@musicmaster

Yes that was showing because i filter 809 product id in product listing

That is not what happens on my test 1.6.1.17. when I filter on a product number. So I suggest that you try without the filter.

Share this post


Link to post
Share on other sites
40 minutes ago, musicmaster said:

That is not what happens on my test 1.6.1.17. when I filter on a product number. So I suggest that you try without the filter.

 

I did the same like you suggested but nothing happens. The problem remain same. Kindly help.

Share this post


Link to post
Share on other sites
1 minute ago, raktrri said:

 

I did the same like you suggested but nothing happens. The problem remain same. Kindly help.

But do you then actually see the "Edit: productname" that I see?

Share this post


Link to post
Share on other sites

Why would it be the core file when on a fresh installation of that PS version I see now problem?

Did you try creating a new product and giving that combinations?

Share this post


Link to post
Share on other sites
1 minute ago, musicmaster said:

Why would it be the core file when on a fresh installation of that PS version I see now problem?

Did you try creating a new product and giving that combinations?

Nope i edited in existing product.

Share this post


Link to post
Share on other sites
13 minutes ago, musicmaster said:

Maybe there is something wrong with that product. So try other products.

Same thing is happening with all the products ...

Share this post


Link to post
Share on other sites

If you understand mysql the next option might be to enable debug_profiling

define('_PS_DEBUG_PROFILING_', true);

It is just a few lines from where you set development mode.

The result is that at the bottom of each page you will see a list of all the mysql commands that have been run for that page.

Share this post


Link to post
Share on other sites
12 hours ago, musicmaster said:

If you understand mysql the next option might be to enable debug_profiling

define('_PS_DEBUG_PROFILING_', true);

It is just a few lines from where you set development mode.

The result is that at the bottom of each page you will see a list of all the mysql commands that have been run for that page.

I followed the instruction and sharing you some queries like insert and update ....
I can see in last 3 insert 'id_product_attribute' is coming as 0

 

Please assists

 

INSERT INTO `ps_attribute_impact` (`id_product`, `id_attribute`, `price`, `weight`)
VALUES (809, 401, 0, 0),(809, 435, 0, 0),(809, 325, 0, 0),(809, 326, 0, 0)
ON DUPLICATE KEY UPDATE `price` = VALUES(price), `weight` = VALUES(weight)

UPDATE `ps_stock_available` SET `id_stock_available` = '1906',`id_product` = '809',`id_product_attribute` = '0',`id_shop` = '1',`id_shop_group` = '0',`quantity` = '33',`depends_on_stock` = '0',`out_of_stock` = '2' WHERE `id_stock_available` = 1906

UPDATE `ps_product` SET `cache_default_attribute` = '0' WHERE id_product = 809

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('1943', '401'), ('1943', '325')

INSERT INTO `ps_product_attribute` (`id_product`, `location`, `ean13`, `upc`, `quantity`, `reference`, `supplier_reference`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`) VALUES ('809', '', '', '', '6', 'JS Ent Hunting Shirts', '', '0', '0', '0', '0', '0', '1', NULL, '0000-00-00')

INSERT INTO `ps_product_attribute` (`id_product`, `location`, `ean13`, `upc`, `quantity`, `reference`, `supplier_reference`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`) VALUES ('809', '', '', '', '6', 'JS Ent Hunting Shirts', '', '0', '0', '0', '0', '0', '1', NULL, '0000-00-00')

INSERT INTO `ps_product_attribute` (`id_product`, `location`, `ean13`, `upc`, `quantity`, `reference`, `supplier_reference`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `minimal_quantity`, `default_on`, `available_date`) VALUES ('809', '', '', '', '6', 'JS Ent Hunting Shirts', '', '0', '0', '0', '0', '0', '1', NULL, '0000-00-00')

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('0', '401'), ('0', '326')

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('0', '435'), ('0', '325')

INSERT INTO `ps_product_attribute_combination` (`id_product_attribute`, `id_attribute`) VALUES ('0', '435'), ('0', '326')

 

 

Edited by raktrri

Share this post


Link to post
Share on other sites
On 2/17/2018 at 2:28 AM, musicmaster said:

I don't have much time at the moment. Did you try a different browser/computer?

I did tried at different computer in different country .... Its seems a core issue after upgrade.

Never mind i will try to upgrade it to 1.7 

Share this post


Link to post
Share on other sites
2 hours ago, raktrri said:

 Its seems a core issue after upgrade.

Never mind i will try to upgrade it to 1.7 

 

A core issue after upgrade? How did you arrive at that idea?

1.7 has its own problems. And the upgrade isn't easy.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×