Categories
View Replies (31)

Resolved Import product types

  1. Digitalconnect
    Digitalconnect
  2. RO CSVI
  3. Thursday, 19 March 2015
  4.  Subscribe via email
Hello,

Im trying to import product types for cherrypicker. For example i would like to add the following;

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

The above line is a part of the header (sku is also included) Now iam looking for a way to add these fields in to the import template but even when i updated the available fields, these are not available.

Iam sure iam missing something but the documentation about adding product types for cherrypicker is a bit tiny. Could you explain me how to do this or help me started? i checked product-types-import-tutorial allready but it seems iam missing something.

Best regards, M
0
Responses (31)
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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
bydomino
bydomino
Accepted Answer Pending Moderation
Hey Roland sorry you've been sick. Actually if you don't mind sending it that would be great. it would give me a jumpstart on coding in what i need to and seeing if it will work how i need it to.
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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
bydomino
bydomino
Accepted Answer Pending Moderation
I also have cherry picker, fastseller, installed on J3.x vm3 and am trying to get product types to work. I don't see any place to get CSVI6 to try it out.

In the end though I want to automate the import of products and product types through a cron job as the data will be automatically created for CSVI to process.
  1. more than a month ago
  2. RO CSVI
  3. # 4
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
Super. I will wait for it.

Best regards, M
  1. more than a month ago
  2. RO CSVI
  3. # 5
rolandd
rolandd
Accepted Answer Pending Moderation
I will send you the packages and description later today.
Kind regards,

RolandD

=========================
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. # 6
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
Thanks again.

At the end i dont care which way but iam sure the best solution is to use fastseller. If you could send me the files and a small explanation, i will figer that out :)

Thanks in advance
  1. more than a month ago
  2. RO CSVI
  3. # 7
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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. # 8
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
This is going to change in CSVI 6, where product types as such won't be supported anymore but simply FastSeller will be supported


That would be the perfect solution. Any suggestion when this (beta) is ready? 2015, 2016?

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



That would be something like this:

PRODUCT_SKU,PRODUCT_TYPE_NAME,PRODUCT_TYPE_PUBLISH,PARAMETER_NAME,PARAMETER_LABEL

Only these fields are not available at the import template. So i can not upload them.

Best regards, M
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
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?
Kind regards,

RolandD

=========================
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. # 10
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
Okee. Seems i now have the tables in mysql database. Still in CSVI import template i can not add fields according product types. So what happens here is that i buyed the system but its not working. Lot of custom things need to be done right? I now tried a lot to fix this but it seems i can't. You always respond to my questions so thats a good thing but its not enough to get me up and running. I just can not import product types, names and parameters because these fields can't be added to a import template.
  1. more than a month ago
  2. RO CSVI
  3. # 11
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
mm, still working on this. Let you know the results
  1. more than a month ago
  2. RO CSVI
  3. # 12
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
Okee super. I keep you informed.
  1. more than a month ago
  2. RO CSVI
  3. # 13
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
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.
  1. more than a month ago
  2. RO CSVI
  3. # 15
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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. # 16
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 17
rolandd
rolandd
Accepted Answer Pending Moderation
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.
Kind regards,

RolandD

=========================
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. # 18
Digitalconnect
Digitalconnect
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 19
rolandd
rolandd
Accepted Answer Pending Moderation
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_?
Kind regards,

RolandD

=========================
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. # 20
  • Page :
  • 1
  • 2


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