Categories
View Replies (14)

Resolved Multivariant Custom Field Import Query

  1. athenacraftsltdltd
    athenacraftsltdltd
  2. RO CSVI
  3. Wednesday, 18 April 2018
  4.  Subscribe via email
Hi All,

Before I forget: Joomla 3.7.4, Virtuemart 3.2.2, CSVi Pro 7.2.3

I'm trying to work out the best way to do the following:

I want to be able to import products with multivariants so that the option dropdowns appear on the product page.
I want to be able to import products with different options (so one product might have weight options, another might have colour and size, another might have pack quantity etc)
I want to be able to do all of this automatically (users will be able to complete appropriate csv files). I have the automation set up via cron job, but the problem I'm encountering here is that the CSVi template needs to be amended if we change the number of variants or the custom labels of them, and then available fields needs to be updated (If I understand the process correctly). I want to be able to hand these tasks over to people and not have to provide back end access to the website. Is this possible?
I don't mind if it requires a number of imports or different templates if I can set them up in advance, but I don't want to be limited by what I've set up - is there any way to dynamically import custom field labels etc?
0
Responses (14)
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
I suspect I've not made that very clear, so if you need more information, just ask.
  1. more than a month ago
  2. RO CSVI
  3. # 1
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
I want to be able to import products with multivariants so that the option dropdowns appear on the product page.

Please have a look at Multi variant import document to know on how to do this import.

I want to be able to import products with different options (so one product might have weight options, another might have colour and size, another might have pack quantity etc)

Have a look at import products with custom fields document. You can add the specific custom fields for a product like below



product_sku;custom_title;custom_value;custom_price;custom_param

H01;Size~Size~Size;34~36~38;24~26~28;Y~N~Y

H02;Weight~Weight~Weight;10~20~15;24~26~28;24~26~28;Y~N~Y


I want to be able to do all of this automatically (users will be able to complete appropriate csv files). I have the automation set up via cron job, but the problem I'm encountering here is that the CSVi template needs to be amended if we change the number of variants or the custom labels of them, and then available fields needs to be updated (If I understand the process correctly). I want to be able to hand these tasks over to people and not have to provide back end access to the website. Is this possible?
I don't mind if it requires a number of imports or different templates if I can set them up in advance, but I don't want to be limited by what I've set up - is there any way to dynamically import custom field labels etc?

CSVI needs to know what new fields have been added or updated in VirtueMart before running an import and that is only possible by updating available fields. What you can do is set available fields update maintenance task to run as a cron a few times so CSVI template fields gets updated. This is explained in [url=https://csvimproved.com/support/questions-and-answers/1081-setting-up-a-cron-job2]Setting up cron job document under Build the cron command section.

I suspect I've not made that very clear, so if you need more information, just ask.

Looks clear to us. Let us know if you need any more information.
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. # 2
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
Hi Tharuna,
Thanks for your response.

I've got a simple mulitvariant import working. I'm importing a parent product and a number of children products that have two custom dropdowns: "Size" and "Quantity". These are custom labels of an existing custom field called "Options". The import file has two columns called "Size" and "Quantity".

Lets suppose that we want to list some other products - these would have four dropdowns, "Colour", "Length", "Width" and "Type". As I understand it, the only way I can import these new labels is to import the custom fields, and then to update the available fields, then amend the import template to include these new fields. I don't want to provide back end access to do this, so I want to know if there's another approach. I want users to be able to add whatever dropdowns they need for whatever products they're listing without having to involve me or have administrative access to the website.

One method I've been looking into is to create an xml file containing the new template and import this, followed by the field update, all done via cron job, but I wondered if there's a simpler way?
  1. more than a month ago
  2. RO CSVI
  3. # 3
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Lets suppose that we want to list some other products - these would have four dropdowns, "Colour", "Length", "Width" and "Type". As I understand it, the only way I can import these new labels is to import the custom fields, and then to update the available fields, then amend the import template to include these new fields. I don't want to provide back end access to do this, so I want to know if there's another approach. I want users to be able to add whatever dropdowns they need for whatever products they're listing without having to involve me or have administrative access to the website.

The order you said is correct, Import the custom fields then update the available fields but it is not a must that the new fields are to be amended to the import template. Users can have the new fields in their import file and with setting Use file for configuration set to Yes on File tab in import template, CSVI will automatically read the new fields from the import file using column headers. Infact CSVI can read all the fields from file with this setting and not only the new fields just that the column headers should match to the name of the field as stored in the database.

One method I've been looking into is to create an xml file containing the new template and import this, followed by the field update, all done via cron job, but I wondered if there's a simpler way?

For imports you can do it Via Frontend using a URL too but you need to update available fields using cron.
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
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
Aha! That sounds like it might be what I need. I'll go away and play with it. Thanks!
  1. more than a month ago
  2. RO CSVI
  3. # 5
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
I am getting an intermittent error though:

An error has occured during the import. Below the information received from the server.
Duplicate entry 'Colour-product-com_virtuemart-import' for key 'component_name_table'

This doesn't occur every time, and it tends to go away if I reprocess the file, but what's going on here?
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Are you using the latest version of CSVI? If yes, Can you go to CSVI About page and click on Verify database button? See if the error is gone after that.
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. # 7
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
Is that the 'fix database' button or am I in the wrong place?
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Yes it is Fix database and in latest version it is Verify database.

To check on this error, can you send us your import file? We will run the import here and see what is causing the error.
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
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
I've sent you an email. Please let me know whether it arrives or not.
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Helllo,
Yes, i received your email. Will let you know on what i find.
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. # 11
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Ian,
Can you please load the attached patch file and see if the duplicate entry error is gone in your import?

patch_vm_2018_04_20.zip
Attachments (1)
patch_vm_2018_04_20.zip
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. # 12
athenacraftsltdltd
athenacraftsltdltd
Accepted Answer Pending Moderation
Hi Tharuna,
I've loaded the patch and run the import a few times now and I've not seen the error. I'll let you know if there's anything to report later, but it looks good, thanks.

PS don't forget to add the patch to the next release ;)
  1. more than a month ago
  2. RO CSVI
  3. # 13
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Ian,
Glad to know that the patch worked. And yes, the fix has been included in our next release.
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. # 14
  • Page :
  • 1


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