1. vinidelmondo
  2. RO CSVI
  3. Thursday, 24 December 2015
  4.  Subscribe via email
Hello Roland,

It would be great if it would be possible to exclude certain products from the export.
I have 'virtual' goods like donations and services. I don't want to send these to the fulfilment company.
In my case I've made a custom field "verzendbaar/nietverzendbaar". If i could filter on this custom field (only export "verzendbaar";), my problem is solved.
This custom field is in the product table.
It would also be workable to use categories instead of a custom field.

No hurry at all!

Merry Christmas!

Suzanne
Accepted Answer Pending Moderation
Hello Suzanne,

All the best wishes for 2016.

This custom field is in the product table.
This means you can use the field for export, however you would need to do a manual filter afterwards.

It would also be workable to use categories instead of a custom field.
The category export already exists for the product export. You do not see it?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
Accepted Answer Pending Moderation
Sorry, my question wasn't clear. I meant in the order export! Both the custom field and the category are indeed available in the product table, but not available in the orders and i need to skip the product records in the order export that are not 'sendable'.

Happy 2016!

Suzanne
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Ha, then we are talking about something completely different :)

A category filter on orders is not easy nor do I think it is a good idea. Order data is static and the categories may change. As for the custom field, is this custom field also in the order table or not?
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
Accepted Answer Pending Moderation
Just to follow up, we are planning to add the category filter on the order export. Let's see if it works out.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
perhaps there is another solution: use the product_vendor_id.
This field is available in the order export. I will have to test if this will do exactly what i want (split the orders up in different exports: one for each vendor).
I'll let you know....
(no hurry at all!)
  1. more than a month ago
  2. RO CSVI
  3. # 5
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!