Skip to content
  • There are no suggestions because the search field is empty.

Export CSV of Unmapped products

Export CSV of Unmapped products

For times when the export csv from the dashboard times out, we can use 

select p.sku, p.product_name, c.full_label from product p join category c on c.id=p.primary_category_id
join marketplace_product mp on mp.sku=p.sku where retailer_name='Princess Polly AUS' and retailer_code='princesspollyau'
and mp.filter_mapping_id is null
limit 25000