Categories
View Replies (3)

Resolved J2Store import problem

  1. dyfrig
    dyfrig
  2. RO CSVI
  3. Tuesday, 22 January 2019
  4.  Subscribe via email
I had a problem with one of my sites which I believe I have resolved but would like some clarification so that I understand what happened and can be sure that I have resolved it.

I am using CSVI pro to import J2Store products (books). The site sells all books available from a distributor. A nightly XML file is sent by the distributor which is converted by my own code into a csv file before using CSV pro to import the books as J2Store products. My code converts the availability code into a 'visibility' field i.e. available books have a 1 in the visibility field. My code did not create an 'enabled' field. Often details of a new book would be sent before it was available so the desired effect would be to create the product, publish it but have the visibility set to 'No'. As far as I was aware it was working fine for many months. Yesterday my client noticed that some books which should have been available were not. Investigation showed that they were set as visible but had not been published. Looking on your forum I found a reference to the fact that the 'Enabled' field was used to publish the article/product and that there had been some change at version 7.7. This is a possible explanation for the problem but does not fully explain why the majority of books were published anyway with only a few not published (61 out of over 14,000).

I have published the problem articles/products and added the creation of an 'enabled' field to my code so all should be OK now however I would still like to improve my understanding of the issue.

Could you let me know what would have been the behaviour of CSVI pro with regards to a CSV file with no 'enabled' field prior to a version 7.7 and after it was released.

I am currently using recent versions of Joomla (3.9.2), J2Store (3.3.4 pro) and CSVI (7.11.0).
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Enabled field has been there in J2Store Product import since the time CSVI started supporting J2Store product import and export. There was no change made specific for this field. Infact the default value for this field is set to 1 which makes the product published by default. Are you sure this field is the cause for the issue?
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. # 1
dyfrig
dyfrig
Accepted Answer Pending Moderation
I based my assumption that there had been some problem, now resolved since version 7.7, on the Forum Post https://csvimproved.com/forum?view=topic&catid=44&id=34454#58912. That problem seems to be the same but in that case always occurring whereas for me it's only some products,

If you cannot explain why my problem was occurring then I think the best course of action will be for me to monitor the website for a few days and, if the problem reoccurs, I can be more specific with exactly what happens and send you a copy of the CSV file, template etc.
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Ok now i think i found what could be creating the problem in your case. Are these Joomla articles/ J2Store products which were not published are new ones and imported for the first time? CSVI looks for enabled field only if the Joomla articles/ J2Store products are new ones and sets the value as in the import file. If this enabled field is not set in import file, the default value for state field which publishes Joomla article is 0 which means unpublished. Let me know if this is your case.
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. # 3
  • Page :
  • 1


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