Products Without Courier

[Derres]

There is any way for see what products have the shipping courier missing ?

 

Thanks

[Derres]

We have a lot of products in the catalogue, we want only know... if we have for error forget a courier in any products. So check what product dont' have the courier.

 

Thanks

[Derres]

Up

[musicmaster]

With Prestools if you search on carrier with specifying a search term you will see all products with a carrier. Prestools is free.

[Derres]

How can we check fast if there is any product that have the courier missing ?

 

We have many products, so is possible we forgot someone or maybe we have add the wrong one to some products.

 

Thanks

[Scully]

As per default, all carriers are available for a product unless you choose specific ones.

You can run a query on your database.

Edited August 24, 2017 by Scully (see edit history)

[Derres]

Ok thx, how exactly ?

Edited August 24, 2017 by Derres (see edit history)

[Scully]

Give yourself at least one or two tries. The forum is about learning and I am willing to help out. But posting the full solution tends to have no learning effect. So first step: figure out the tables we need.

Edited August 24, 2017 by Scully (see edit history)

[Derres]

if i make a question is becouse we need a solution. If i already know the solution i don't stay to write here asking...

 

Thanks

Edited August 25, 2017 by Derres (see edit history)

[Scully]

@Derres:

 

For me it  seems you even wouln't take a minute on your own to come closer to a solution or make some very basic research.

I was willing to help but if the only goal for you is other people make your work, find somebody else.

Edited September 1, 2017 by Scully (see edit history)

[Derres]

Up, someone have the solution ?

[Derres]

There is any way for check fast if there is any product that have the courier missing ?

 

We have many products, so is possible we forgot someone or maybe we have add the wrong one to some products.

 

Thanks

[NemoPS]

A product should have all carriers assigned by default, so no, there is no way to know at glance if any does not have specific carriers assigned, inside prestashop.
you can, however, use a sql query like
select id_product from ps_product

This will give you all ids

Now 

select id_product from_ps_product_carrier

Clean up results and use array_diff to see what's missing

[Derres]

The delivery couriers are not assigned by default, also if you do copy of the products it is not assigned and you need add it for every new product

 

There isn't any module to attach to prestashop foro manage the products ? I mean a solution more easy for normal employees ?

 

Thanks

Edited August 30, 2017 by Derres (see edit history)

[NemoPS]

If there is no carrier, all of them will be available for that product

[Derres]

If there is no carrier, all of them will be available for that product

KK, thanks a lot

[selectshop.at]

I mark this as solved. The answer of your problem is already given in #13. All carriers will be available for all products, unless you don't deselect them on the (specific) product configuration. If you want to contra-check possible product configuration errors you may have done, than use the SQL queries nemops posted in #13

[Derres]

Yeah, we want only know if for error for some products we have add the wrong courier or we have forgot to give the courier.

 

We ask this becouse we have more than 80 couriers.

[selectshop.at]

For to see if there is one product without, you can use SQL Queries named. For error you can only see which ID-Carrier is set to product with ID-> There is no clear data for that.

 

SHOW TABLE 'databasename'.'ps_product_carrier';

 

Or export your products with a tool like this: https://www.prestashop.com/forums/topic/540614-tutorial-export-products-with-all-the-fields-supported-by-csv-import/

or

you use the Presta Store Manager which is free for 30 days use. See link in my signature.

[Derres]

Thanks and after 30 days what is the price of your products manager ?

 

Btw i want only a list of products name with products courier assigned for have a fast check that everything is ok.

 

We need only this.

 

Thanks

Edited August 31, 2017 by Derres (see edit history)

[selectshop.at]

It depends of the version you are taking: https://www.prestashopmanager.com/order/

 

It's not my product. I'm only working with it by the same way as with Prestashop. I'm earning nothing with it.