Import product types #7234

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.

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 :)

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?

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,

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.

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,

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.

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.

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.

Lot of custom things need to be done right?

If you want to use Product Types, which is a feature of VirtueMart 1, it is usually a manual table creation unless you already have the tables. Installing a VirtueMart 2 or 3 version, won't give you these tables. This is going to change in CSVI 6, where product types as such won't be supported anymore but simply FastSeller will be supported, then you don't have to create those tables anymore either.

I just can not import product types, names and parameters because these fields can't be added to a import template.

Let's focus on the first import. The product type import. How does your import file look like for that?

Any suggestion when this (beta) is ready? 2015, 2016?

Last week :) I just have been unable to create a new beta release due to ill health. I can e-mail you the files if you are interested. Let me know.

I have just re-read this thread again and something caught my eye.

Because i now created all product types and names by hand in fastseller so these tables exists somewhere. Just needed to import the values.

This information exists in the fastseller tables and not in the vm_product_type tables. That is why you will need to run all 3 product type imports via CSVI if you want to use the vm_product_type tables. The question is if you still want to go this route or give the FastSeller implementation of CSVI 6 a go.

I will send you the packages and description later today.

Hello,

CSVI 6 is available from the Download section just where you get all other downloads. However CSVI 6 with Fastseller support is not yet up for download due to sickness on my part. However I can send you the package if you are interested, let me know and I will do so. Otherwise the download will be made available later this week.

Running the import via a cron job is no problem as it will be a regular import like any other.

Hello,

I managed to get CSVI 6 beta 5 out the door yesterday. This is now available from the Downloads and you can also download the FastSeller addon to get started with FastSeller.