Hi, I wonder if you can help, Id like to export a list of products that have a custom field value.
out of about 300,000 products we have about 1000 products that have a custom group assigned to them (with 4 fields) Id like to export the SKUs and Category paths of Just these 1000 products.
Can this be done?
Many thanks
- webstar
- RO CSVI
- Thursday, 09 May 2019
- Subscribe via email
0
Accepted Answer
Pending Moderation
Hello,
Glad to know your issue is solved. Please leave us a review on Joomla Extension Directory.
Glad to know your issue is solved. Please leave us a review on Joomla Extension Directory.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Hi there - Yes the Cron job worked - Many thanks - this is great.
Incremental Exports will be great when implemented.
Many thanks for your help
Incremental Exports will be great when implemented.
Many thanks for your help
Accepted Answer
Pending Moderation
Hello,
As of now batch exports is not possible but this is a feature which is in our todo list and will be included in future.
Overriding system limits will work only when you have a VPS or Dedicated server. One other option is to run the export as a cron job using command line. Can you try Setting the export as a cron job and check if it works?
Is there no way to export in increments like you can do on import overrides?
As of now batch exports is not possible but this is a feature which is in our todo list and will be included in future.
Or Can you advise of what to set the system override settings to?
Overriding system limits will work only when you have a VPS or Dedicated server. One other option is to run the export as a cron job using command line. Can you try Setting the export as a cron job and check if it works?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
Ive tried - 1-1000 and this is fine - but anything over 50,000 and Im running into trouble.
Is there no way to export in increments like you can do on import overrides?
Or Can you advise of what to set the system override settings to?
Is there no way to export in increments like you can do on import overrides?
Or Can you advise of what to set the system override settings to?
Accepted Answer
Pending Moderation
Hello,
It is possible that your server has hit its limits when doing the export of 300,000 products. Can you try the export with 1000 products and check how it goes? To set the export limit, in your export template on File tab set From and To values to range from 1 to 1000 and run the export. Check if export works without any errors.
Status error: 500
Status message: Internal Server Error
It is possible that your server has hit its limits when doing the export of 300,000 products. Can you try the export with 1000 products and check how it goes? To set the export limit, in your export template on File tab set From and To values to range from 1 to 1000 and run the export. Check if export works without any errors.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Accepted Answer
Pending Moderation
yes as I feared - I'm gettign
Status error: 500
Status message: Internal Server Error
can you think of any way to get round this?
Status error: 500
Status message: Internal Server Error
can you think of any way to get round this?
Accepted Answer
Pending Moderation
Yes its a field, Thats a good pointer I'll give it a go. how well do you think it will work with 300,000 products tho?
Accepted Answer
Pending Moderation
Hello,
What is the type of custom field you have? If it is a String custom field what you can do is add this custom field as a export field and using CSVI Skip rule create a rule which will skip the rows for which the custom field value is empty. Apply this rule on your custom field and run the export.
Let me know if it helps.
What is the type of custom field you have? If it is a String custom field what you can do is add this custom field as a export field and using CSVI Skip rule create a rule which will skip the rows for which the custom field value is empty. Apply this rule on your custom field and run the export.
Let me know if it helps.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
- Page :
- 1
There are no replies made for this post yet.
Be one of the first to reply to this post!
Be one of the first to reply to this post!
Please login to post a reply
You will need to be logged in to be able to post a reply. Login using the form on the right or register an account if you are new here. Register Here »