Resolved Not saving the mapping

Hello,
You need to use product import template to import the fields you mentioned, you can map your price field to product_price and availability to product_availability field and then do the import. Hope this helps.

This is perfect, but how can I do it?

Thanks a lot,
Davide

Hello Davide,

In this case you should be OK using 1 template since all fields are in this one file. This will mean that both price and quantity are updated at the same time.

Hi Roland,

in my feed I have:
id;Name;Price 3;Price 2;Manufacturer;Quantity;


Thanks, Davide

Hello Davide,

Whether you can do it with 1 or 2 templates really depends on what is in your import file. Since I don't know that I am assuming you are using the fields in the template rather than the column headers, both files that you are importing will need at least the same order of the fields. If the order is different then the fields won't match.

Depending on what you are importing you may need two templates as well. Again, since I don't know which fields you are importing, it is hard to tell.

Yes, I know this, but my request is different.

I need to update the price and the quantity (availability of the product).

Do I need 2 templates or can I do it with only one?


Thanks,
Davide

Hello,

I need to update price and quantity, do I need to do 2 template and 2 jobs or there is any way to do more simply?

Are you looking for updating price minimum and maximum quantity? In that case you can use price template to update both price and quantity, for quantity use fields price_quantity_start and price_quantity_end. You can have a look at import VirtueMart price documentation to know on this.

Thank you very much Tharuna, just did it and it works.

Last question
I need to update price and quantity, do I need to do 2 template and 2 jobs or there is any way to do more simply?


Thanks a lot for your support!
Davide

Hello,
Thank you so much for sending the mysql dump, it really helped. I could see that three fields in #__csvi_maps table are missing in the sql dump file you sent. Not sure how it has gone missing. Can you go to your phpmyadmin and delete the tables #__csvi_maps and #__csvi_mapheaders? Then run the below query by pasting it on SQL tab in your phpmyadmin so new tables are created. You can then try to do a fresh field mapping of fields and see if it works.

DROP TABLE IF EXISTS `sr16_csvi_mapheaders` ;

CREATE TABLE IF NOT EXISTS `sr16_csvi_mapheaders` (

	`id` INT(10) NOT NULL AUTO_INCREMENT,

	`map_id` INT(10) NOT NULL,

	`csvheader` VARCHAR(100) NOT NULL,

	`templateheader` VARCHAR(100) NOT NULL,

	PRIMARY KEY (`id`)

) CHARSET=utf8 COMMENT='Holds map field mapping';



DROP TABLE IF EXISTS `sr16_csvi_maps` ;

CREATE TABLE IF NOT EXISTS `sr16_csvi_maps` (

  `csvi_map_id` INT(10) NOT NULL AUTO_INCREMENT,

  `title` VARCHAR(100) NULL DEFAULT NULL,

  `mapfile` VARCHAR(100) NULL DEFAULT NULL,

  `action` VARCHAR(100) NULL DEFAULT NULL,

  `component` VARCHAR(100) NULL DEFAULT NULL,

  `operation` VARCHAR(100) NULL DEFAULT NULL,

  `auto_detect_delimiters` TINYINT(1) UNSIGNED NULL DEFAULT '1',

  `field_delimiter` VARCHAR(1) NULL DEFAULT ',',

  `text_enclosure` VARCHAR(1) NULL DEFAULT '"',

  `locked_by` INT(10) NULL DEFAULT NULL,

  `locked_on` DATETIME NULL DEFAULT NULL,

	PRIMARY KEY (`csvi_map_id`)

) CHARSET=utf8 COMMENT='Holds map configurations';

Hi,

thank you much, email sent.

Waiting for you,
Davide

Hello,
Can you send me mysql database dump of your field mapper tables? The tables are #__csvi_maps and #__csvi_mapheaders. Please post it as a private message or email it to tharuna@csvimproved.com.

Hello,

Only for the field mapping.

Hello,
Is this a problem only with field mapper page? how about other pages? Can you test the templates page by creating a new template and check if you see it in the templates list?

Just tested, but it's not a cache problem..

Hello Davide,
If you see them in database then field mapper functionality has worked good. I am thinking if this could be something to do with your site cache. Can you try to clear the cache and check?

Hi,
Just checked and they are present.

How can I see them in the control panel?


Thanks a lot,
Davide

Hello Davide,
Thank you so much for sending the details. I checked your site for field mapper, there is actually no error in your field mapper and not even javascript error, the field mapper says its been saved. Can you go to your phpmyadmin>> select your database >> Look for table #__csvi_maps and #__csvi_mapheaders and see if you have rows in these tables?

PM 4 you.

Thanks,
Davide

Hello,
Can you send a private message of your Joomla administrator login details? I will check in your site directly.

Hello,

just tested, but I have the same problem, anything is saved...

I'm going crazy!