Characteristic will not update in csv import

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #250729

-- url of the page with the problem -- : v1.tcpirate.com/index.php/hikashop-menu-for-products-listing
-- HikaShop version -- : 2.6.4

I have 2 files 02-v1-exp.csv which is the upload file I want to update my product with.
After importing the file..

×
Message

71 products found : 0 new products imported, 0 invalid product code, 71 already existing products

I go to the front side and see that the main product information is updated, but not the characteristics..
Specifically column
Custom T-shirt Colors
I want to change the data from a text to a coloricon...
Yes I already created the options on the front side, but it does not matter.. The CSV data for the characteristic name will not upload using the csv. I thought it was because it was a html tag but I also tried to rename a product and that did not work..
:blink:
I can update price but not the actual name of the variant.

What is the solution?
:whistle:

Sell more, sell better, do not cheapen your brands.

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13705
  • MODERATOR
8 years 11 months ago #250749

Hi,

I don't see why you could update the price and not the name.
There must be a problem with your CSV file.
Could you provide a copy of the file ?

Please Log in or Create an account to join the conversation.

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #250804

I am sorry.. I forgot to up load those.. duh! :ohmy:
I downloaded the file and made the changes... 02
I then verified that the changes that I needed to make did not accept. 03

Thanks Nicholas

Sell more, sell better, do not cheapen your brands.
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13705
  • MODERATOR
8 years 11 months ago #250817

Hi,

I don't understand why you're trying to change the characteristics values via the CSV import.
Simply edit the characteristic in the backend, and modify the values there. It will apply automatically to all the products using these values.

If you try to change the values in the CSV and import it back, the import system won't find the values that you have in your CSV in the characteristic you configured and it will use instead the product_id to update the variant data but the values of the characteristic won't be changed.

Please Log in or Create an account to join the conversation.

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #250900

I would have rather just built a csv and import it one time and be done, but characteristics are not importable on a fresh install. According to your own forum I must manual create them. I have 50 products with up to 65 colors each, based on specific vendors.

The direct importing of this csv does not work for this one item..

How can I add more items when the first one fails ?

What am I supposed to do?

You want me to manually do something that should be an automated task.. that is counter productive and labor intensive.
You must have some other way!!!

Sell more, sell better, do not cheapen your brands.

Please Log in or Create an account to join the conversation.

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #250905

:(
The issue is that I configured how I wanted the products to look on a testing server.
Once I like it, I exported it, and it should import directly...
No it does not do that. Why have an export import function that does not work?
I CREATED A FRESH INSTALL
I imported 02-v1-exp.csv to the test site
v2.tcpirate.com
it failed to import correctly as seen in the hikashopexport.csv

logic dictates if you export something from a system...
the system created the file
the file was populated with similar items.
the file was imported into a duplicate system
the file failed to duplicate the results..
What failed? the system...
the system needs a correct import export feature.

What I am understanding is that you want me to manual add and modify 68k products because your system does not produce the expected results from one example product. This is the proof that something needs to be reconsidered in the logic.

What am I supposed to do?
What the F@#$ am I supposed to do?
I have too much time invested to abandon the project now.

Sell more, sell better, do not cheapen your brands.
Attachments:

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13705
  • MODERATOR
8 years 11 months ago #250942

Hi,

No the system works fine. Just follow the documentation which explains how to use it:
www.hikashop.com/support/documentation/73-hikashop-import.html
There is no need to use swear words. We'll be happy to help you if you ask nicely.

If you have one color attribute with 65 colors for 50 products. Creating manually the characteristics before the import is no problem.
It will take only 5 minutes to create the characteristic with the 65 possible colors via the Products>Characteristics menu.
Once done, you can import your CSV with all your products which uses the values of the characteristic and it will generate all the variants of all the products based on what you have in the CSV.
It's the same with the custom product fields. You need to precreate the custom field before you import a CSV which has a value for each product for that custom field.

Please Log in or Create an account to join the conversation.

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #250983

You first need to create the characteristic and the possible values via the menu Products>Characteristics of your website before importing the CSV and of course the name of the column and the values you put in the CSV for it must correspond to the name of the characteristic (or its alias) and its values. If you were using a characteristic called 'color' you might setup the values red, blue, yellow and green, even though you won't apply all of them to every product. But they must exist if you are going to use them ever in the import.

That is directly copied from the page you sent me too..
It states very clearly the characteristics must be created manually in the backed before you can make variants.
That is the problem.. I have to manual input the characteristics first.

According to your directions... are you telling me that I can create one or characteristics then import the rest? because if you are I am telling you it does not work.. I have tried it. I have gone as far as to import the characteristics directly into the table using mysql.. this worked fine, until I decided to change the variants from text to icon... thus creating this issue in the forum and being told again to follow..

I will tell you what mr. smart guy.. I will set up a blank installation send you my csv file and access to the administrator side and you do it.. That is what your guarantee says.,.

I am starting to curse because I am tired of trying to do something that should be so simple..
Make a single product they way you want it to look on a testing server..
Export that information to csv
open csv add the variants needed
Go to live site and import amended csv.
Product finished..
Site done..

If this not possible how will I be able to recover from a disaster, where I do not have access to the site.. All I have is my csv?
This is correct? It is impossible to import all the products characteristics and all data needed to populate the site.

Please make it clear if I am not understanding.
:evil: :evil: :evil:

Sell more, sell better, do not cheapen your brands.

Please Log in or Create an account to join the conversation.

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #250985

nicolas wrote:
If you have one color attribute with 65 colors for 50 products. Creating manually the characteristics before the import is no problem.
It will take only 5 minutes to create the characteristic with the 65 possible colors via the Products>Characteristics menu.
.


There are 67 unique colors for this product.
each product has not the same charteristics nor colors...
there are an estimated 800 different unique colors that are associated with 50 types of products...
You are not listening.. to the problem...
It is not a 5 minute job,
I also want this first set to be coloricon..
Thus let me offer you the solution to go and create 67 characteristics in 5 mins for color-icon...
:blink: :angry:
Bet you don't want to do that...


As far as asking nicely... I have and was told this is possible to do with your cart before i invested the time into this project.
Now when I have everything the way I like it.. I find it is not possible to do a simple export import. What a failure that is!!!

Sell more, sell better, do not cheapen your brands.

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13705
  • MODERATOR
8 years 11 months ago #250987

Hi,

As I said, you don't have to create 67 color characteristics. You can just create one color characteristic with all the possible values for all the products. And please remember that I didn't know that you had so many colors and so many characteristics until this message. Up until now, you only talked about the color characteristic.

If you have too many values/characteristics and that you don't want to add them manually, then export the hikashop_characteristic table from the old database of your PHPMyAdmin and then import it in the new database. That takes only 2 minutes.

And I never ever said to anyone that characteristic values can be imported/exported through the interface of HikaShop since that has never been possible so far.

Finally, if you worry about loosing data and you do an export/import of the products to avoid that, then you're not using the correct function. That option is only there to make it fast to export/import products. It won't help for all the other data you have on your website. If you want to backup your website data, and not jsut the products, you should use a backup solution like akeeba backup. That way, you'll be able to recover your website in just a few minutes and not only the HikaShop products.

The following user(s) said Thank You: ElectronicCarpenter

Please Log in or Create an account to join the conversation.

  • Posts: 52
  • Thank you received: 0
8 years 11 months ago #251023

Excellent advice...
I have a complete backup solution already..
I gave up on the characteristic import., it is not possible with csv.
I have tried every way and the only way is to inject them into the database directly.
My client will have to add them or pay me to inject them..
Thanks.. for dealing with this.

Sell more, sell better, do not cheapen your brands.

Please Log in or Create an account to join the conversation.

  • Posts: 84313
  • Thank you received: 13705
  • MODERATOR
8 years 11 months ago #251042

Hi,

Note that PHPMyAdmin can export/import CSV files of tables. But yes, it has to be done in the database directly.

Please Log in or Create an account to join the conversation.

Time to create page: 0.073 seconds
Powered by Kunena Forum