How to UPDATE all price from ext. Excel file?

  • Posts: 156
  • Thank you received: 0
9 years 2 months ago #244664

-- HikaShop version -- : last
-- Joomla version -- : last
-- PHP version -- : last

I have about 10 products and I have even prices for each variant. So I have to handle about 30 prices for each item.
The update need too much time and it is really difficult to manage.

Is there a way to link a price to each cell in an Excel file? So should just update the excel file and automatically the prices are also updated.

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

  • Posts: 26275
  • Thank you received: 4045
  • MODERATOR
9 years 2 months ago #244671

Hi,

Please understand that "last" is not a valid version number.
If you do not want to provide that information ; do not provide it, it will be better that providing that kind of useless information.
Thanks for your understanding.

About your question, you can't use "excel" file but you can use CSV files.
See : www.hikashop.com/support/documentation/167-massaction-form.html

Regards,

Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

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

  • Posts: 156
  • Thank you received: 0
9 years 2 months ago #244702

I have no problem to provide the version, but I have all them always update to latest version.

BTW:
Joomla 3.5.1
HykaShop 2.6.3

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

  • Posts: 156
  • Thank you received: 0
9 years 2 months ago #244703

Are you sure I can auto-update (from CSV file) the prices of variants) (I have a dropdown menu with some option and different prices for each)

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

  • Posts: 84313
  • Thank you received: 13702
  • MODERATOR
9 years 2 months ago #244713

Hi,

Yes, the export and the import of HikaShop handle variants and their prices.

You can also use a mass action with an action "display the results" on the product_name, product_type, price_value and the characteristics columns and when you process the mass action, you'll see a listing of the products/variants and you can double click on the price_value cells of the table in order to update them.

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

  • Posts: 156
  • Thank you received: 0
9 years 2 months ago #245170

Sorry but the guide is badly written and it is very difficult to understand the function of specific options

On the public page I have e.g. these product

Product: Shoes
Color: Blue
Price: 10$

Color: Red
Price: 20$

Color: White
Price: 30$

Product: Watch

Stripe: Rubber
Price: 50$

Stripe: Leather
Price: 100$

Stripe: Steel
Price: 150$

I would like to update the prices on a daily basis.

I have an Excel file (price.csv) with

COLUMN1: SHOES

CELL A1:B1 = 10$
CELL A1:B2 = 20$
CELL A1:B3 = 30$

COLUMN1: WATCH

CELL A2:B1 = 50$
CELL A2:B2 = 100$
CELL A2:B3 = 150$

How can I set the price in way to update the price automatically, getting the price from excel file?

Last edit: 9 years 2 months ago by SuX.

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

  • Posts: 84313
  • Thank you received: 13702
  • MODERATOR
9 years 2 months ago #245175

Hi,

Supposing that "SHOES" and "WATCH" are the product codes, your CSV should be this:

product_code,product_parent_id,color,stripe,price_value
SHOES,,Blue,,
SHOES_blue,SHOES,Blue,,10
SHOES_red,SHOES,Red,,20
SHOES_white,SHOES,White,,30
WATCH,,Rubber,,
WATCH_Rubber,WATCH,,Rubber,50
WATCH_Leather,WATCH,,Leather,100
WATCH_Steel,WATCH,,Steel,150
If you configure these two products through the interface and then click on the export button of the products listing, it will give you a CSV containing all the columns including these ones with the values like in the example CSV I gave you above.
So you can use that as a basis.

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

Time to create page: 0.064 seconds
Powered by Kunena Forum