Skip to main content

Import products?

More
13 years 9 months ago #80738 by xtech86
Import products? was created by xtech86
Hello,

I am looking to create some thing like:

www.national.co.uk

has on their home page, a product search option and selling products.

Can I easily update the database of hikashop i.e. prices with an import option? as we have thousands of tyres.

Regards
Tony

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

More
13 years 9 months ago #80746 by sambob
Replied by sambob on topic Import products?
Hi Tony,

Yes VERY easy to import. That is one of the main strengths with HikaShop.

Import via csv/spreadsheet.
Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

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

More
13 years 9 months ago #80749 by xtech86
Replied by xtech86 on topic Import products?
Sounds very good!

Does this allow importing updates? i.e. if the price changes on our system from supplier we can just re-import?

What kind of search modules does Hika offer?

Regards
Tony

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

More
13 years 9 months ago #80760 by sambob
Replied by sambob on topic Import products?
Yes import via CSV, or text import.

For functionality (search, filters, layouts...) why not chackout the Demo - menu at top of page
Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'
The following user(s) said Thank You: Xavier

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

More
13 years 9 months ago - 13 years 9 months ago #80944 by xtech86
Replied by xtech86 on topic Import products?
Hello,

I did quickly try it but got an unknown columns on import.

Do you have any docs on how to import events? i.e. what you have to do to make a successful import?

Many thanks
Tony
Last edit: 13 years 9 months ago by xtech86.

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

More
13 years 9 months ago #81000 by sambob
Replied by sambob on topic Import products?
Hi tony,

best way is to create a product in Hikashop and then export it to get a template of the headings/columns.

I use 'Open Office' for opening up csv's and importing as it handles CVS's better than Excel. ANd I do most of the data manipulation in Excel.
Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'
The following user(s) said Thank You: Xavier

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

More
13 years 9 months ago #81470 by xtech86
Replied by xtech86 on topic Import products?
Thank you..

I do not think this is going to work as a simple solution.

The client will need to do updates weekly, this would be replacing the existing prices and also adding new ones if there are any. They receive a file from the manufacture and this is the pricing list.

See the attached file, as we are going to be having non tech users updating the records..

Please let me know if you think this can be achieved simply.

Regards
Tony

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

More
13 years 9 months ago #81477 by sambob
Replied by sambob on topic Import products?
Very easy...

If it is just price upadate, you can do a text import with just product ID and price.
Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

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

More
13 years 9 months ago #81479 by xtech86
Replied by xtech86 on topic Import products?
You say it is very easy, how do we associate the product ids when the other system is different as Hikashop uses its own product id's?

Regards
Tony

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

More
13 years 9 months ago #81486 by sambob
Replied by sambob on topic Import products?
Well not sure of the schematic of the 'other system', but how I do it is via an excel spreadsheet were I have done a vlookup that correlates one system to the other.

Once you have imported you products initially, export them and you will have a list of products with not only Product_ID as well as a product number (which will be a point of reference between systems.
Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

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

More
13 years 9 months ago #81783 by xtech86
Replied by xtech86 on topic Import products?
Thanks guys, I'm really starting to get some where now.

I'm now on to Custom Fields.. I want to add them to the Products not Address? is this only available in the paid version? as we cannot select Table it's automatically selecting Address.

Many thanks
Tony

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

More
13 years 9 months ago #81792 by sambob
Replied by sambob on topic Import products?
Yep, Essential and above.

Version Comparison

Its more than worth it (IMHO)
Don't look at what is and ask 'why?'; look at what isn't and ask 'Why Not!'

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

Time to create page: 0.268 seconds
Powered by Kunena Forum