Resolved Import product types

Hello,

Product types exist of 3 imports as you have seen in the tutorial. Looking at your header line, you are going wrong there. You can't have the kleur field in the product type parameters, it comes in the last import product type names.

Have you made the 3 required import files? That would help to oversee the process, by creating the product types file, the product types parameter file, and the product types names file.

With those files, you can see if all is set correct.

Dear Rolandd, Thanks a lot for your response

Okee sorry i have to be more clear.

I created the product types and values by hand. Now iam trying to import products and everything works fine. Only i need for every product to set which product type to use and which value this product type should be.

For example i have a producttypename color with a parameter color which can be blue white and more. Now for example i have product A which should use color blue. - Product B should use color white - Product C use another producttypename, parameter and value. Now which fields should i add so cherrypicker knows which products should use parameters and values?

Hope you understand my question

Best regards, M

Only i need for every product to set which product type to use and which value this product type should be.

So you only need to run the Product type names import, this is the last step in the tutorial.

Your CSV file will need to look like the example, the first 2 columns are fixed, the rest are the field names you created. As you can see not all fields have a value, that will be the same as yours. You can either create one file for product A and B and another file for product C or just make one file with all the product types and leave the ones empty that do not apply to that product.

Hopefully that is clear

Thanks for your response again.

Well, in that case (making just one file), the headerline i placed in the first post should be oke right?:

product_type_name,$,parameter_name,$,parameter_label,$,kleur,$

product_type_name and parameter_name are fixed as i understand. I also like to add the label (parameter_label) and in my case: kleur (color) is a field name i created. But how can i add these fields to a import template? Because even when i updated the available fields, these are not available in my import template.

Best regards, M

the headerline i placed in the first post should be oke right?:

This is not right, compare it to the example CSV file, it starts with product_sku and product_type_name. In your case the file should be "product_sku","product_type_name","kleur". Is the kleur field not available either?

PS: i forgot to mention that of course i also added the sku at the start of the file. Just dont understand how i can add these fields to my import template. Installed the plugin and updated the available fields. Still i can not add them to my template.

btw thanks for your help. I know its possible, just need to know how

Best regards, M

No also kleur is not available

Hello,

If you don't see the parameters as available fields, I wonder if things are setup correctly. You could just do the 3 imports as explained in the document, if anything already exists, it would simply update it. If it doesn't exist, it will create it.

Hello,

Yes i will give this a try, but even at the first step it seems i need to add PRODUCT_TYPE_NAME and this is not possible as you can see here:

http://goo.gl/r8IB1l

Best regards, M

Hello,

It is clear where it goes wrong. You have chosen the Import -> VirtueMart -> Product while you should be choosing Import -> Cherry Picker Product Types -> ... As you stated in your first post, you want to import for the cherry picker.

Hi Rolandd,

Thanks again for your response. Sry for my late replay (i was on short holidays this weekend). I think you are right. thats exactly what i did.Only problem here is i can not import/update cherrypicker fields and i publised the plugin (VM Cherry Picker addon for CSVI Pro). I need to think for a moment.

Best regards, M

Hello,

The VM Cherry Picker addon for CSVI Pro is of no use in CSVI 5, this is an addon for CSVI 6 Pro beta. I assume you are not using CSVI 6 Pro beta, in that case you can uninstall the plugin.

Only problem here is i can not import/update cherrypicker fields

Do you even have any tables that start with vm_producttype_?

Hello,

Your right again. Iam using 5.21.1. No i do not have any tables with product types. Searching for days but i still dont know how to get these. Should i create them by hand in phpmyadmin?

Best regards, M

Hello,

To create the tables manually, you need these 3 statements if I remember correctly.

CREATE TABLE `X_vm_product_product_type_xref` (

	`product_id` INT(11) NOT NULL DEFAULT '0',

	`product_type_id` INT(11) NOT NULL DEFAULT '0',

	INDEX `idx_product_product_type_xref_product_id` (`product_id`),

	INDEX `idx_product_product_type_xref_product_type_id` (`product_type_id`)

)

COMMENT='Maps products to a product type'

;

CREATE TABLE `X_vm_product_type` (

	`product_type_id` INT(11) NOT NULL AUTO_INCREMENT,

	`product_type_name` VARCHAR(255) NOT NULL DEFAULT '',

	`product_type_description` TEXT NULL,

	`product_type_publish` CHAR(1) NULL DEFAULT NULL,

	`product_type_browsepage` VARCHAR(255) NULL DEFAULT NULL,

	`product_type_flypage` VARCHAR(255) NULL DEFAULT NULL,

	`product_type_list_order` INT(11) NULL DEFAULT NULL,

	PRIMARY KEY (`product_type_id`)

)

COLLATE='utf8_general_ci'

;

CREATE TABLE `X_vm_product_type_parameter` (

	`product_type_id` INT(11) NOT NULL DEFAULT '0',

	`parameter_name` VARCHAR(255) NOT NULL DEFAULT '',

	`parameter_label` VARCHAR(255) NOT NULL DEFAULT '',

	`parameter_description` TEXT NULL,

	`parameter_list_order` INT(11) NOT NULL DEFAULT '0',

	`parameter_type` CHAR(1) NOT NULL DEFAULT 'T',

	`parameter_values` VARCHAR(255) NULL DEFAULT NULL,

	`parameter_multiselect` CHAR(1) NULL DEFAULT NULL,

	`parameter_default` VARCHAR(255) NULL DEFAULT NULL,

	`parameter_unit` VARCHAR(32) NULL DEFAULT NULL,

	PRIMARY KEY (`product_type_id`, `parameter_name`),

	INDEX `idx_product_type_parameter_product_type_id` (`product_type_id`),

	INDEX `idx_product_type_parameter_parameter_order` (`parameter_list_order`)

)

COMMENT='Parameters which are part of a product type'

;

Change the X to your own prefix.

Thanks again for your response. I will try this and keep you informed. btw, do you know where it go wrong? Its not the normal way right?

Best regards, M

Hello,

It has been a while since someone asked about using this but I kind of recall this had to happen last time as well. Yes it is normal because most people are not using VM1 anymore, so the tables no longer exist by default. I am planning to take a closer look as well, perhaps improve the instructions if this is really needed.

Aa okee, Now before i created this tables. I was thinking that csvi was importing values for the tables from fastseller to make use of the cherrypicker. Because i now created all product types and names by hand in fastseller so these tables exists somewhere. Just needed to import the values. Asked Galt also some questions but he refers to csvi support.Iam now a bit stuck with importing values for cherrypicker. If i created this tables by hand in phpmyadmin, i think that thi swont work with fastseller and cherrypicker. Iam i right or should it work?

Thanks in advance.

If i created this tables by hand in phpmyadmin, i think that thi swont work with fastseller and cherrypicker. Iam i right or should it work?

It should work if you are using the Cherry Picker for Virtuemart using Product Types version from Galt.

Okee super. I keep you informed.

mm, still working on this. Let you know the results