Top Menu

× To post a question you must be signed in.

Filter & Delete Certain Product Variants

Anson
Topic Author
Offline

More

16 Nov 2019 20:37 #5863 by Anson

Filter & Delete Certain Product Variants was created by Anson

Hi Support,

1. As the subject, for using the Shopify Excel-like Spreadsheet app,

is it possible to Filter & Delete Certain Product Variants?

2. My case is that I want to Filter & Delete Certain Product Variants without any variant images assigned.
(Note: it's critical to help fix the product image error caused by 3rd-party app)

Please help check and advise the above issues. Thanks.

Please Log in or Create an account to join the conversation.

Super User
Offline

More

18 Nov 2019 15:08 - 18 Nov 2019 15:08 #5864 by Super User

Replied by Super User on topic Filter & Delete Certain Product Variants

We added "delete by import" option recently.

You need to have column in your file that has value of "yes" for rows corresponding to products/variants you want to remove.

You can create column in excel and using IF function to set "yes" for such items.

Let's say image is H column and Parent is A column

=IF(A2 && H2="","yes","")

Thanks,

Last edit: 18 Nov 2019 15:08 by Super User.

Please Log in or Create an account to join the conversation.

Anson
Topic Author
Offline

More

18 Nov 2019 15:40 #5865 by Anson

Replied by Anson on topic Filter & Delete Certain Product Variants

Thanks for your quick reply.

Please advise:

1. Could you provide CSV/XLSX template file for "delete by import"?

2. Where could we import the file for "delete by import"?
Is it in the below screen and what box is needed to be ticked?
ibb.co/fDnbDGF

3. For using "delete by import", how could we get the list of deleted ID/SKU number?

As it's critical for us to get the list for our 3rd party marketplaces removal.
Thanks again.

Please Log in or Create an account to join the conversation.

Super User
Offline

More

19 Nov 2019 11:20 #5866 by Super User

Replied by Super User on topic Filter & Delete Certain Product Variants

Hi,

- same file you normally use for import can be used fro removal.
- you just need to add column you will use to tell what products/variants corresponding to rows should be removed.
- you can prepare such column by using excel functions primarily "=IF(...;...;...)" .
Thanks,

Please Log in or Create an account to join the conversation.

Time to create page: 0.033 seconds

Powered by Kunena Forum

2CheckOut.com Inc. (Ohio, USA) is an authorized retailer for goods and services provided by HOLEST.