Categories
View Replies (13)

Resolved Export file, products_sku empty

  1. Flyed
    Flyed
  2. RO CSVI
  3. Monday, 23 January 2017
  4.  Subscribe via email
Joomla 3.6.5, VM 3.0.18 CSVI 7.02

Export Template with product_sku, product_discount_id and discountamount.
Export works, but product_sky is empty...

I dont know, why..

Thanks for help!
0
Responses (13)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The reason why you don't see the product_sku field is because you also have a multi-variant label set to product_sku. So CSVI skips exporting the product_sku field. Attached is the multi-variant field that is set to product SKU. This just doesn't look right to me, so I have changed the Product SKU to Custom label for now, but it looks like this custom field doesn't even belong there. This is for product SKU 580765502.

If you don't need the multi-variant field there, I would suggest to just remove it.

You can not export the product_sku field as well.
Attachments (1)
multi-variant-sku.png multi-variant-sku.png
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
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I don't know why either because there is no debug log to check. Which type of export have you chosen in your template?

Is there anything in the export file?
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. # 2
Flyed
Flyed
Accepted Answer Pending Moderation
Sorry, Roland!
Logfile attached...

Thanks for help!

Flyed
Attachments (1)
com_csvi.log.101.zip
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Flyed,
It is strange that you have product_sku field in your export fields but it is not added to export query as per your debug log and so the field is empty. One thing to check here is that you have set category filter in your export template, what if you remove the filter and export all products? Is it the same? You can also try updating available fields before doing the export.
Kind regards,

Tharuna

=========================
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
Flyed
Flyed
Accepted Answer Pending Moderation
Thank you, Tharuna.

Without category filter same problem, update avaiable fields same problem...
New Log and file attached...
export.csv export.csv log_short.txt
Attachments (3)
export.csv
export.csv
log_short.txt
  1. more than a month ago
  2. RO CSVI
  3. # 5
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you send me your Joomla administrator login details to check? I don't see any option why your product_sku doesn't work. Let me have a look at your site and see if i find anything.
Kind regards,

Tharuna

=========================
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. # 6
Flyed
Flyed
Accepted Answer Pending Moderation
Ok, PM
  1. more than a month ago
  2. RO CSVI
  3. # 7
Flyed
Flyed
Accepted Answer Pending Moderation
Maybe any relation to this thread?
https://csvimproved.com/forum?view=topic&catid=44&id=33646#52970
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
No, that issue was in CSVI 7.0.0 version, you are already on 7.0.2 so the issue is already fixed with this version. There is something really wrong in reading product_sku in your site. Can you also please send me database access details?
Kind regards,

Tharuna

=========================
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. # 9
Flyed
Flyed
Accepted Answer Pending Moderation
Ok, PM again...
  1. more than a month ago
  2. RO CSVI
  3. # 10
Flyed
Flyed
Accepted Answer Pending Moderation
Thank you, Roland!

Export works perfect now!
Additional i removed the multi-variant field...

Thanks for fantastic support!

Flyed
  1. more than a month ago
  2. RO CSVI
  3. # 11
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Flyed,

Glad to hear it is working for you as well.

I would appreciate if you could post a review on the Joomla! Extension Directory. Thank you.
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. # 12
Flyed
Flyed
Accepted Answer Pending Moderation
Done, Roland!

Thank you!

Flyed
  1. more than a month ago
  2. RO CSVI
  3. # 13
  • Page :
  • 1


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