Skip to main content

How to export products and categories to csv ?

More
15 years 6 months ago #11204 by rikatos
How to export products and categories to csv ? was created by rikatos
Hi all, just started using hikashop.

I can find where to import product csvs, but cannot find where to export them first ? Maybe Im missing something but any ideas ?

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

More
15 years 6 months ago #11206 by nicolas
Replied by nicolas on topic Re: How to export products and categories to csv ?
You're not missing anything. There is no export for now.

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

More
15 years 6 months ago #11209 by rikatos
Replied by rikatos on topic Re: How to export products and categories to csv ?
hmm ok. but there is a import yes ? If so is there a format that is required ?

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

More
15 years 6 months ago #11210 by nicolas
Replied by nicolas on topic Re: How to export products and categories to csv ?
Yes, there is a specific format required. The format is explained on that page with some examples:
www.hikashop.com/en/support/documentatio...hikashop-import.html

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

More
15 years 6 months ago #11216 by rikatos
Replied by rikatos on topic Re: How to export products and categories to csv ?
Ahh ok, that is a shame.

I have over 800 products some with up to 8 variants and want a easy way to go in and change the prices, not to have to step through them, but it seems the variant, the prices and product are 3 seperate tables.

I also need to be able to create many products with variants at once by a csv upload but this seems I cant do it. Unless I am missing something.

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

More
15 years 6 months ago #11218 by nicolas
Replied by nicolas on topic Re: How to export products and categories to csv ?
You can import products and their variants with the import screen. It's written clearly in that documentation:

Finally, you can also insert variants of products. You will have to specify in the product_parent_id column the product_code of the main product which must be inserted before the variants in the file. You will also have to have column names matching the characteristics in the store.
For example, suppose that you have a product with 1 characteristic being the size and two variants:
product_code,product_parent_id,size
main_product,,big
first_variant,main_product,big
second_variant,main_product,small

You will be able to insert one price per variant or product.

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

More
15 years 6 months ago - 15 years 6 months ago #11219 by rikatos
Replied by rikatos on topic Re: How to export products and categories to csv ?
excellant, that makes sense, but each variant need to be associated with a characteristic if I am correct ? Is there a way to create one with the csv if it doesnt exist, or to use a characteristic already created ?
Last edit: 15 years 6 months ago by rikatos.

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

More
15 years 6 months ago #11221 by nicolas
Replied by nicolas on topic Re: How to export products and categories to csv ?
HikaShop is not yet able to create characteristics and values on the fly when you import products. You need to pre create the characteristics and the values via the interface. Then, you can use these characteristics as columns in your CSV and their values as values of the columns as explained in the previous quote.

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

More
15 years 6 months ago #11222 by rikatos
Replied by rikatos on topic Re: How to export products and categories to csv ?
Once again brilliant, as long as I know it can do it, then theres a way !

So to summerise.

If I want to create a product which has specific characteristics and prices for each I just need to have created those characteristics I require beforehand in the backend, and then import my csv. Simple stuff.

Then forever more I can just import just the fields I need to change, such as prices.

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

More
15 years 6 months ago #11228 by nicolas
Replied by nicolas on topic Re: How to export products and categories to csv ?
Yes. You will have to specify the product_code column when you import update CSVs so that hikashop can associate the new information with the product in the database.

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

More
14 years 10 months ago #28846 by Bugger101
Replied by Bugger101 on topic Re: How to export products and categories to csv ?
Hi!

How do I export product prices? I am using the export tool but it doesn't seem to show the prices on it.

Thanks :)

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

More
14 years 10 months ago #28876 by nicolas
Replied by nicolas on topic Re: How to export products and categories to csv ?
Prices are exported along with the products information when you use the export button on the products listing. You can try on our demo website, the prices are there.

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

More
14 years 10 months ago #28953 by Bugger101
Replied by Bugger101 on topic Re: How to export products and categories to csv ?
Ok cool, must be blind :)

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

More
11 years 6 months ago #193021 by sedonasky
Replied by sedonasky on topic Re: How to export products and categories to csv ?
Please post us when there is an export feature.

The other method to do this is with a text editor on the database, using careful find and replace of the prices. I just did a test and it worked!

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

More
11 years 6 months ago #193058 by Xavier
Replied by Xavier on topic Re: How to export products and categories to csv ?
Hi,

Please specify what you are looking for.
This topic is a very old one, so many things has changed since. ;)

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

More
11 years 6 months ago #193141 by sedonasky
Replied by sedonasky on topic Re: How to export products and categories to csv ?
We have a lot of products that we need to change prices for. Three years later, is there a way now to export the product database? (So we can then make price changes, then import.)

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

More
11 years 6 months ago #193146 by Xavier
Replied by Xavier on topic Re: How to export products and categories to csv ?
Hi,

Yes, via the menu Products, click on the export button in the toolbar, then edit the csv file and import it via the menu Products > Import.

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

Time to create page: 0.260 seconds
Powered by Kunena Forum