1. Lambros
  2. Pre-sale questions
  3. Friday, 18 October 2019
  4.  Subscribe via email
Hi there,

I have some pre sales question , so i d like to ask you for some things if your component can do it.
1. I have an eshop in hika shop with two prices. The one price is the retail price and the secend price is access price for users (it works as wholesale)
In cart a user can add only the second price (wholesale) (if you need a screenshot for better explanation please ask for it)
So can i export in xml both prices? So to have in xml in one line the retail price and on other line the wholesale price?

Also in the same xml its very important to have and other characteristics like product code, description etc (no in seperate xml)

Thanks in advance
Accepted Answer Pending Moderation
Hello,
I have an eshop in hika shop with two prices. The one price is the retail price and the secend price is access price for users (it works as wholesale)
In cart a user can add only the second price (wholesale) (if you need a screenshot for better explanation please ask for it)
So can i export in xml both prices? So to have in xml in one line the retail price and on other line the wholesale price?

Yes the retail price is stored with product in hikashop_products table and the second price for specific user or access level is stored in hikashop_price table. Both these prices can be exported using HikaShop Product export template.

Also in the same xml its very important to have and other characteristics like product code, description etc (no in seperate xml)

Yes you can export these in same XML file with same HikaShop Product export template.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 1
Accepted Answer Pending Moderation
Hi thanks for your reply
i try your demo but i cant find the tables with name hikashop_product and hikashop_price.
Can you please tell me what is the templates fields for two aboves?
i want to try it if it please before to buy the products.
Thanks again
  1. more than a month ago
  2. Pre-sale questions
  3. # 2
Accepted Answer Pending Moderation
Hello,

The tablenames were just for reference, you won't find them in RO CSVI itself as you should not have to worry about which tables contain what. So to export both prices, you need a Hikashop Product export template. You should be able to add a second price to one of the products on the demo site and then run the Hikashop example product export Do note, that a product with 2 or more prices will be exported as many times as it has prices. So in CSV format it looks like this:

"product_name","product_price","related_products","category_path","product_parent_id","product_published","product_quantity","product_manufacturer_id"
"Brown shoes","120.00","","product category/Shoes/Men","0","1","-1","0"
"Brown shoes","100.00","","product category/Shoes/Men","0","1","-1","0"

In XML format, this will mean you get 2 nodes with different prices. So not a single node with 2 price subnodes.

Let me know if that helps.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 3
Accepted Answer Pending Moderation
Hi!
Thank you very much for your support. i appreciated!
I try exactly you wrote , i put 2 differents prices on demo products (one in retail and one in price access) i used the hikashop export products but again only one price displayed. (the price in product access) Not 2 prices....
I want to buy the software but if it not doing what i need then i can not use it.. :(
Can you try on your demo to see if it works?
Also if i buy the software can you add in my site (i will send you the keys) the templates fields to make it works (two export 2 prices) ??

thanks in advance
  1. more than a month ago
  2. Pre-sale questions
  3. # 4
Accepted Answer Pending Moderation
Hi!
Thank you very much for your support. i appreciated!
I try exactly you wrote , i put 2 differents prices on demo products (one in retail and one in price access) i used the hikashop export products but again only one price displayed. (the price in product access) Not 2 prices....
I want to buy the software but if it not doing what i need then i can not use it.. :(
Can you try on your demo to see if it works?
Also if i buy the software can you add in my site (i will send you the keys) the templates fields to make it works (one export 2 prices) ??

thanks in advance
  1. more than a month ago
  2. Pre-sale questions
  3. # 5
Accepted Answer Pending Moderation
Hello,

Can you try on your demo to see if it works?
Sure, see my response below.

Did you change the price on the Porsche Carrera 4964? If yes, I ran the export and the export file contained both prices in there. You will see there are 2 nodes for the Porsche, each has one of the prices.


<item>
<product_name><![CDATA[Porsche Carrera 4964]]></product_name>
<product_price><![CDATA[18.00]]></product_price>
<related_products><![CDATA[Porsche_Carrera|Porsche_Carrera_4993|Porsche_Carrera_4S996|Porsche_Carrera_911|Porsche_Carrera_Cabriolet|Porsche_Carrera_Targa|Porsche_Cayman_S]]></related_products>
<category_path><![CDATA[product category/Automobile/Cars]]></category_path>
<product_parent_id><![CDATA[0]]></product_parent_id>
<product_published><![CDATA[1]]></product_published>
<product_quantity><![CDATA[-1]]></product_quantity>
<product_manufacturer_id><![CDATA[0]]></product_manufacturer_id>
<product_sort_price><![CDATA[20.00000]]></product_sort_price>
<product_price><![CDATA[18.00]]></product_price>
<product_price><![CDATA[18.00]]></product_price>
</item>

I am guessing you added the two extra product_price fields at the end because there is already one as the second field. As I mentioned in my previous reply, you cannot export the single product with multiple prices. Does that clarify things?

Also if i buy the software can you add in my site (i will send you the keys) the templates fields to make it works (one export 2 prices) ??
The price is only for the software not the installation. If you want us to install and configure everything that will be done based on an hourly rate.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 6
Accepted Answer Pending Moderation
Hi thank you very much for your example!
ok i saw the two prices. As i mentioned in my first post i need the retail price and the price access in xml. Not the two price access.
See the attachment please, it will help !!
Attachments (1)
  1. more than a month ago
  2. Pre-sale questions
  3. # 7
Accepted Answer Pending Moderation
Hello,
The field to export retail price is product_msrp. I have added that field in our demo site for Example HikaShop Product export template. Please try the export and check.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. Pre-sale questions
  3. # 8
Accepted Answer Pending Moderation
Hi!
Yes this is the solution for my question.
I think i can work with your component!
  1. more than a month ago
  2. Pre-sale questions
  3. # 9
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!
Lambros
Submit Your Response
Upload files or images for this discussion by clicking on the upload button below. Supports gif,jpg,png,jpeg,zip,rar,pdf,csv,txt,tsv,xml,docx,doc,xls,xlsx,ods,tgz
• Insert • Remove Upload Files (Maximum File Size: 4 MB)
In this section you can provide your site details at here and it visible to the moderators only.