MAssive insert product

andreasuriani
Topic Author
Offline

12 years 1 month ago #167736 by andreasuriani

MAssive insert product was created by andreasuriani

-- HikaShop version -- : latest

Hi All,

i need to insert almost 500 product in the same category, but with different price (also photo and download file).
Is it possible to do a Massive insert? Maybe via database?
How?
Is there a documentation?

Thanks
Andrea

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

lousyfool
Offline

12 years 1 month ago #167758 by lousyfool

Replied by lousyfool on topic MAssive insert product

andreasuriani wrote: Is there a documentation?

See here: www.hikashop.com/support/support/documen...hikashop-import.html

Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

The following user(s) said Thank You: Jerome

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #167759 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Thanks to sharing it.
But, can i have an exemple fo CSV file, please?

Thanks
Andrea

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

lousyfool
Offline

12 years 1 month ago #167760 by lousyfool

Replied by lousyfool on topic MAssive insert product

The easiest way to create a perfect example for your specific case is - logically! - an export of existing products.

Please keep reading the documentation. Also, if you look closely at the forums here, you'll see that there's a section dedicated to this, where you might find more hints and tips: www.hikashop.com/support/support/documen...hikashop-import.html

Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

The following user(s) said Thank You: andreasuriani

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #167761 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

I can't find anythings about export product!

How can i do this??

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #167762 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Sorry, i'm an idiot!

I've export it.
i'm trying to make a good csv file.

Thanks for now!

Andrea

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

andreasuriani
Topic Author
Offline

12 years 1 month ago - 12 years 1 month ago #167767 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Ok, it works but not at 100%.

The column called "files_name" doesn't works. Hikashop doesn't give me a wrong feedback , but the download name doesn't displayed.

Made i some mistake?

In attachment Csv File.

Andrea

Last edit: 12 years 1 month ago by andreasuriani.

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #167778 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Hi,
also the "images" it doesn't work. (url is correct)

Can somebody help me?

Andrea

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

Xavier
Offline

12 years 1 month ago #167851 by Xavier

Replied by Xavier on topic MAssive insert product

Hi,

Could you give us a link to your website in order to see how is the product displayed on frontend ?
The csv seems to be correct. Are you sure that you have the desired data at the correct place in FTP ?

For example the folder "folder" present in the "media/com_hikashop/upload" one ? Are the "taste.jpg", "preview.jpg" file existing ?

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #167859 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Ciao Xavier,
i've solved issue about image, but not about file name.

The cvs is correct, but it seems that Hikashop, not consider string "file_name".

How can i solve it?

Andrea

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

nicolas
Away

12 years 1 month ago #167861 by nicolas

Replied by nicolas on topic MAssive insert product

Hi,

There is no file_name column for the CSV import. It's files_name
Note also that you'll want to add that fix or it won't work since we didn't do a release yet with the fix :
www.hikashop.com/support/forum/content-c...-working.html#166258

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #167976 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Hi,
ok , i'll try to make a correction on php file and i will send u the result.

Andrea

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #168003 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Hi Nicolas,
I changed the string to the file "import.php" as you suggested, but it still does not work.
After uploading the file, the file name is the address of the folder.

Can you help me?

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

nicolas
Away

12 years 1 month ago #168030 by nicolas

Replied by nicolas on topic MAssive insert product

Hi,

And did you change the column name to files_name instead of file_name in your CSV as I also said in my message ? Otherwise, it won't work

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #168087 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Yes i did.

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

nicolas
Away

12 years 1 month ago #168186 by nicolas

Replied by nicolas on topic MAssive insert product

Then I don't know.

Can you provide the CSV file that you're using right now so that we can check it and try to reproduce the problem on our end ?

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #168197 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

HI nicolas,
in attachment the csv file.

Please, let me know asap, beacuse for this reason the Photostore is closed at he moment!

This attachment is hidden for guests.
Please log in or register to see it.

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

nicolas
Away

12 years 1 month ago #168213 by nicolas

Replied by nicolas on topic MAssive insert product

Hi,

Great, I found the problem.
Change the code:

Code:

$array = $this->_separate($product->$name);
			if(count($array) != count($files)) continue;
			$key = 'file_'.$var;
			foreach($files as $k => $file){
				$files[$k]->$key = $array[$k];
			}

to:

Code:

$this->_separate($product->$name);
			if(count($product->$name) != count($files)) continue;
			$key = 'file_'.$var;
			foreach($files as $k => $file){
				$files[$k]->$key = $product->{$name}[$k];
			}

in the file administrator/components/com_hikashop/helpers/import.php and that will fix the problem. We'll include the fix in next version of HikaShop.

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

andreasuriani
Topic Author
Offline

12 years 1 month ago #168301 by andreasuriani

Replied by andreasuriani on topic MAssive insert product

Great Nicolas!

Works perfectly!!

Merci!

And

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

Time to create page: 0.339 seconds