Categories
View Replies (13)

Resolved import product colors via custom fields for all

  1. icsolutions
    icsolutions
  2. RO CSVI
  3. Tuesday, 13 February 2018
  4.  Subscribe via email
Hi,

Joomla! 3.8.2
VirtueMart 3.2.4
CSVI pro 7.3.0
CSVI Import Custom Fields For All 7.4.1
Custom Fields for All 3.1.2

I installed all plugins and followed the instructions I found but it's not going as expected.

In the VM custom fields, I created a new custom field -> plugins -> customfieldsforall and I added all available colors from all products and I added the label for 2 languages.

WHAT I WOULD LIKE TO ACHIEVE:
I would like to create csv files with products_sku, custom_title, custom_valie and custom_param and add available colors per product in this way.

WHAT HAPPENS:
At the import, the colors I added in the csv are added to the product but also ALL colors which I added into the custom fields in the beginning are showing on the product -> so lots of colors double
+ in the custom fieds, the colors I added to the product, are also added in the custom fields plugin, so there are the colors also double.

What is the right way to import colors to the website?

thanks in advance

Geert
0
Responses (13)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Geert,
Joomla! 3.8.2
VirtueMart 3.2.4
CSVI pro 7.3.0
CSVI Import Custom Fields For All 7.4.1
Custom Fields for All 3.1.2

First thing i noticed here is the version of CSVI package and CSVI custom fields for all plugin are different. You need to update your CSVI package to 7.4.1 version.

In the VM custom fields, I created a new custom field -> plugins -> customfieldsforall and I added all available colors from all products and I added the label for 2 languages.


WHAT I WOULD LIKE TO ACHIEVE:
I would like to create csv files with products_sku, custom_title, custom_valie and custom_param and add available colors per product in this way.

You can follow the examples explained in Custom fields for all for VirtueMart document.

WHAT HAPPENS:
At the import, the colors I added in the csv are added to the product but also ALL colors which I added into the custom fields in the beginning are showing on the product -> so lots of colors double
+ in the custom fieds, the colors I added to the product, are also added in the custom fields plugin, so there are the colors also double.

What is the right way to import colors to the website?

Can you post sample of your import file, import debug log and screenshots of how you have your Custom fields for all field set in VirtueMart custom fields page?
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
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi,

Now it's a real mess. Sorry, not saying it's your fault, this is what I've done :
I reinstalled CSVI pro (he gave an error by normal updating)

That didn't made a change so I tried to reinstall the custom fields for all plugin also but that didn't helped either.

In VM i created the custom field again and now I'm not able anymore to add a hex color code :-(, only color name.

When I try to import a product and instead of mentioning the color code in the csv (what I tried bfore) I placed the color name because I had to input this in the custom fields.
The import seems to work in the backend, the product has the custom fields I added and they were not added twice in the VM custom fields part but they are not showing in the front end.

All help is welcome, I'm getting little bit crazy.

thanks
Attachments (4)
com_csvi.log.97.zip
Knipsel-cffa.JPG Knipsel-cffa.JPG
Knipsel-printscreen-productpage-customfields.JPG Knipsel-printscreen-productpage-customfields.JPG
Knipsel-product-front-end.JPG Knipsel-product-front-end.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 2
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
That didn't made a change so I tried to reinstall the custom fields for all plugin also but that didn't helped either.

I did not say it will help but having two extensions with different versions of same package can give a lot of conflicts.

In VM i created the custom field again and now I'm not able anymore to add a hex color code :-(, only color name.

This is not caused by CSVI update as it does not handle any color codes but just imports what is in the file to database.

When I try to import a product and instead of mentioning the color code in the csv (what I tried bfore) I placed the color name because I had to input this in the custom fields.
The import seems to work in the backend, the product has the custom fields I added and they were not added twice in the VM custom fields part but they are not showing in the front end.

In your custom fields settings on VirtueMart custom fields page you have set Cart Attribute to Yes but Cart Input to No, can you change Cart Input to Yes and check your frontend?
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
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi

front-end looks better with cart input to Yes, thank you

but it's not OK yet. Because I can't input hex colors, I don't get these colors in the front end, neither I get to see the lable of the color.

Could it be compatibility issue with newest version of CSVI and custom fields for all plugin?

If we get this functional, how do I import the colors per product? should it work the way I tried before?

thanks
Attachments (1)
Knipsel-multi-colors.JPG Knipsel-multi-colors.JPG
  1. more than a month ago
  2. RO CSVI
  3. # 4
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
Can you send me your import file? I will run the import here and check what is going on with hex color codes.
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. # 5
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi,

we are almost there!
I'm able to see the colors and i'm able to import, ONLY he adds an empty color at the end of every product.

log in attachment com_csvi.log.111.zip

thanks already
Attachments (1)
com_csvi.log.111.zip
  1. more than a month ago
  2. RO CSVI
  3. # 6
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
In your import file for custom_title and custom_value is there an extra ~ at the end or at the starting? If its there you need to remove it and import. Post your import file so i can check for it.
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
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi,

please find test import file

test-import-kleuren.csv
Attachments (1)
test-import-kleuren.csv
  1. more than a month ago
  2. RO CSVI
  3. # 8
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
You have an extra # in front of your custom_value 035b31. Remove it and run the import to avoid empty value.
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
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi,

I retried this and the following happens:
- the colors are all getting twice in the product custom fields.

Twice in VM control panel -> products -> custom fields and twice in products -> choose product that has been updated -> custom fields
On both places, the colours are double!

In attachment you can find my csv file and log file

thanks already com_csvi.log.115.zip test-import-kleuren.csv
Attachments (2)
com_csvi.log.115.zip
test-import-kleuren.csv
  1. more than a month ago
  2. RO CSVI
  3. # 10
tharuna
tharuna
Accepted Answer Pending Moderation
Hello,
The problem is MySql is not case sensitive by default, since the lower case version of these codes are already in database and when CSVI compares with the ones imported against the values in database it collects these lower case code ids also and inserts them which is the cause for duplicates. Can you load the attached patch file and check if there are no duplicates?

patch_CF4ALL_2018_02_19.zip
Attachments (1)
patch_CF4ALL_2018_02_19.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. # 11
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi,

overwritten the file with your file but exactly the same result. everything in double.

would it be helpful if I wrote the colors all in lower case?
  1. more than a month ago
  2. RO CSVI
  3. # 12
icsolutions
icsolutions
Accepted Answer Pending Moderation
Hi,

When I import and I put all colors in lowercase, it seems to work!

I'm testing further but it looks good!
  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!