2

I am trying to make a configurable product (clothes with size and color) shipped. When I create a simple product I see shipment method : enter image description here

But when I select a configurable product (choose the size and the color), I don't see the shipment method and I'm forwarded directly to the payment page. And I must say these products have weight.

enter image description here

When I see to the DB (table catalog_product_entity), I see the main product is Configurable while the others (combination size-color) are virtual. I hanged the "virtual" attribute to "simple" , still didn't work

enter image description here

1

I have tested a configurable product with Magento 2.2.2 version. When creating a configurable product with child products which are 'automatically' generated. These child items will have no weight. As a result, they are virtual products. It's a default Magento (in my case, Magento 2.2.2).

We can change the type_id in catalog_product_entity table (As you said, you did it, but no success). I think the reason for that you enabled Flat table: Catalog > Store Front > Use Flat Catalog Product. In this case, we need to reindex our database.

| improve this answer | |
  • Sorry couldn't upvote your answer because I have less than 15 reputations – Ismail Berlin Mar 19 '18 at 9:33
  • @IsmailBerlin no worries. Just want to check my knowledge also. – Khoa TruongDinh Mar 19 '18 at 11:59
  • @KhoaTruongDinh i have same issue facing but my client is not adding weight in all products so my all product is simple products and no weight available also when i run reindex command then 2-3 day working fine after some time then this issue coming again – Rakesh Donga Jul 22 '19 at 16:36
3

You can convert all virtual products to the simple product by just one query.

update catalog_product_entity set type_id = 'simple' where type_id = 'virtual';

But beware, this query converts all virtual products to simple. (better to create DB backup before the start)

| improve this answer | |
0

You could solve this by manually adding weights to individual products if the product list is not bigger. I had similar issue and I solved it by adding weights to the products. This approach has two benefit. The variations of products will not list on the cart & shipping option missing error is also managed.

| improve this answer | |
0

I solved it by adding weights to the products. Thanks. Magento 2.3.5

Thanks a lot!

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.