[solved]How to import different (quantity) prices

  • Posts: 101
  • Thank you received: 12
11 years 6 months ago #100377

Hi,

I think I'm confused in how to import different prices for the same product.

For example you have ProductAA and the price is 1 euro when you buy a couple.
When you buy atleast 100 the price is 0.6 euro.

How can I import this? How does the CSV look like? Can this be done with one line or do you have to make a line for each price.

Thanks.

Last edit: 11 years 6 months ago by SG.

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

  • Posts: 12953
  • Thank you received: 1778
11 years 6 months ago #100405

Hi,

The best solution would be to :
- Export all of your products through a CSV file
- Edit and import this file

Hope this will help you.

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

  • Posts: 101
  • Thank you received: 12
11 years 6 months ago #100412

Sorry I guess I didn't explain myself that good.

We want to use the info from the products from redshop.
And also the prices. If I recall correctly redshop calls it "shoppergroup price" but we just use it to have several minimum quantity for one product.

Each product have two prices.
For instance:
ProductAA 1,00 euro (minimum for example 4)
ProductAA 0,60 euro (if minimum quantity is 100)


I want to setup a csv file since hikashop will be empty.
I was wondering how you can add two (or more prices) and minimum quantity for each product.

I just found this post: www.hikashop.com/en/forum/2-general-talk...inimum-quantity.html

If I understand correctly you can use | for the price and and minimum quantity.
Is this correct?

Is there another way of doing this?

It's just that for the moment the prices and minimum quantities are in separate columns when we export the date from redshop so if there is no other way in hikashop I'll have to find a way to combine it with the | character to separate the values.

Any tips is highly appreciated to facilitate the process.
I have around 4130 products for now to import with each two prices and minimum quantity.

Greets

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

  • Posts: 82760
  • Thank you received: 13347
  • MODERATOR
11 years 6 months ago #100632

That is indeed correct.

In your example, you would have something like that:

product_code,price_value,price_min_quantity
ProductAA,1.0|0.6,4|100
There is no other way.
So yes, you will have to do some search and replace to have | between the prices in your CSV.

The following user(s) said Thank You: SG

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

  • Posts: 101
  • Thank you received: 12
11 years 6 months ago #100637

Hi,

Thanks for the update.
Now I know for sure that this is the only way. I will figure something out to simplify it for the customer.

Greets

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

Time to create page: 0.068 seconds
Powered by Kunena Forum