Import products?

  • Posts: 6
  • Thank you received: 0
11 years 11 months ago #80738

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.

  • Posts: 260
  • Thank you received: 25
11 years 11 months ago #80746

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.

  • Posts: 6
  • Thank you received: 0
11 years 11 months ago #80749

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.

  • Posts: 260
  • Thank you received: 25
11 years 11 months ago #80760

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.

  • Posts: 6
  • Thank you received: 0
11 years 11 months ago #80944

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: 11 years 11 months ago by xtech86.

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

  • Posts: 260
  • Thank you received: 25
11 years 11 months ago #81000

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.

  • Posts: 6
  • Thank you received: 0
11 years 11 months ago #81470

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

Attachments:

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

  • Posts: 260
  • Thank you received: 25
11 years 11 months ago #81477

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.

  • Posts: 6
  • Thank you received: 0
11 years 11 months ago #81479

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.

  • Posts: 260
  • Thank you received: 25
11 years 11 months ago #81486

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.

  • Posts: 6
  • Thank you received: 0
11 years 11 months ago #81783

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.

  • Posts: 260
  • Thank you received: 25
11 years 11 months ago #81792

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.084 seconds
Powered by Kunena Forum