Product prices not displaying when using CSV

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #273387

-- url of the page with the problem -- : www.clydesdale.net/clydesdale-products/p.../4411-noah-coveralls
-- HikaShop version -- : 3.1.1
-- Joomla version -- : 3.7.2
-- PHP version -- : 5.6.30
-- Browser(s) name and version -- : Chrome

Hello,
I have a few products where I have cron job running to update product prices with a CSV. I have noticed that when it updates all of the variant prices the prices do not display on the front. I have to add a main product price for them to show. However I I created a test product manually and this doesn't seem to need a main product price for the variant prices to display.

How is this mean't to work and how can I get the prices to display without add a main product price?

Thanks

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273390

Hi,

A price isn't necessary in the main product. So this indicate a problem with your CSV.

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

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #273421

Hello I have attached the CSV I am using to upload. Can you tell me what is missing?

File Attachment:

File Name: CLYPRCLST.csv
File Size:3 KB


This is also the link to the product page for product code CLY 582 124 ##
www.clydesdale.net/clydesdale-products/p.../4411-noah-coveralls

Thanks

Attachments:
Last edit: 7 years 10 months ago by dancingkazzaf.

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273436

Hi,

That CSV is indeed not a valid import CSV.
If you have variants in your products you need:
- a column for each characteristic with the value of the characteristic for each variant (and the default value for the main product)
- a row for each main product placed before the rows of its variants
- a column product_parent_id where you have the product_code of the main product for each variant.
Then that would import properly through the import system and product cron update plugin.

Now what you can do is to use a mass action with an import filter instead. The massaction system is an approach close to the database structure below so it doesn't need the extra things I talked above because it has a lot less processes trying to generate stuff for you automatically and just does a simple update.
www.hikashop.com/support/documentation/167-massaction-form.html

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

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #273500

So I still need a default value for the main product then? Can you supply an example or edit my CSV so you can show how its all meant to be layed out.

The system that the client exports from doesn't use a main product just has product codes and prices for all the variants ence why the CSV only has them on.

There system also wouldn't have all the characteristics on, thats something that has been added in Hikashop all we really want to do is have a CSV that updates pricing?

Is there a way to only update pricing using CSV?

Last edit: 7 years 10 months ago by dancingkazzaf.

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273506

Hi,

To get an example of what you would need for the standard import system, just select a product configured like you want in the backend products listing and click on the "export" button.
Then, remove the rows for the categories structure and the columns that don't have any data and you'll be left with a pretty good example of what you need.

So with the restrictions you have for how your CSV is generated it's better to go through the mass action system as I explained in my previous message. With it, you don't need to have the main product, or the characteristic columns in the CSV. So do that and you'll have your solution.

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

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #273597

The issue is the system that the client exports from doesn't have the characteristics or the main products. This is all created in Hikashop.

Cant you just update pricing from the product codes?

Last edit: 7 years 10 months ago by dancingkazzaf.

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273605

Hi,

It seems you didn't understand my two previous messages. So I'll keep it short:
Yes, by using the mass actions system.

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

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #273677

Am I still using mass action with a CSV or using another filtering option. I have read the documentation but I still don't understand how I am mean't to just import the prices of the CSV correctly.

I have just read this post: www.hikashop.com/forum/import-export-csv...tegory-id-s-csv.html
I am already importing the CSV through mass action but the prices wont display on the front.

Last edit: 7 years 10 months ago by dancingkazzaf.

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

  • Posts: 83799
  • Thank you received: 13571
  • MODERATOR
7 years 10 months ago #273679

Hi,

You need to go in the menu System>Mass actions, create a new mass action, with a filter to import the CSV and process the mass action in order to update your prices.

If you have a problem with that method, then please provide a screenshot of the settings of your mass action.

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

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #273820

Hello,
Yes that is exactly what I have been doing.

I have attached a screenshot

Attachments:

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

  • Posts: 26233
  • Thank you received: 4036
  • MODERATOR
7 years 10 months ago #273845

Hello,

Your mass action does not have any "action" set.

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: 256
  • Thank you received: 2
7 years 10 months ago #273866

Thanks but what action am I meant to be using?

I selected update values > then price_value but then its asking for INT, FLOAT, STRING or OPERATION and there is an empty field next to it. What am I meant to use to update the prices?

Regards

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

  • Posts: 256
  • Thank you received: 2
7 years 10 months ago #274156

Hello I am still waiting for help for my issue. I am using Mass Action to upload my CSV but it not work correctly. You guys said I need to setup an Action I have checked documentation but I still don't understand the values etc.

What action do I need to update prices from a CSV?

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

Time to create page: 0.057 seconds
Powered by Kunena Forum