[Skip to main content](#vessel-content)

#   Multi Level Pricing &amp; Quickbooks Export

##

- **[interactivewest](/forum/user/32561-interactivewest "View interactivewest's Profile")**
- [![interactivewest's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32561-interactivewest "View interactivewest's Profile") Topic Author
- [ Offline](/forum/user/32561-interactivewest)

Less More

- Posts: 11
- Thank you received: 0
-
-

12 years 5 months ago [\#155342](#155342) by [interactivewest](/forum/user/32561-interactivewest "View interactivewest's Profile")  *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#155342 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")* was created by *[interactivewest](/forum/user/32561-interactivewest "View interactivewest's Profile")*

-- url of the page with the problem -- : [ www.netlocity.info/index.php/products](http://www.netlocity.info/index.php/products)
-- HikaShop version -- : HikaShop Starter: 2.3.0
-- Joomla version -- : 3.2.3
-- PHP version -- : 5.3.26
-- Browser(s) name and version -- : Firefox 29.0.1

2 Questions -

1) Is there a way to export orders to quickbooks? via CSV or by Plugin?

2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

12 years 5 months ago [\#155353](#155353) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#155353 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Hi,

1. Yes, via plugin: [ www.hikashop.com/forum/2-general-talk-ab...tegration.html#93276](http://www.hikashop.com/forum/2-general-talk-about-hikashop/78984-quickbooks-integration.html#93276)

2. Yes, that's possible with the Business edition of HikaShop.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[firstek](/forum/user/32862-firstek "View firstek's Profile")**
- [![firstek's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/32862-firstek "View firstek's Profile")
- [ Offline](/forum/user/32862-firstek)

Less More

- Posts: 3
- Thank you received: 0
-
-

12 years 4 months ago [\#158554](#158554) by [firstek](/forum/user/32862-firstek "View firstek's Profile")  Replied by *[firstek](/forum/user/32862-firstek "View firstek's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#158554 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

I have got the business edition , could you provide me more information about the Multi Level Pricing Available for different groups of customers?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[Xavier](/forum/user/4105-xavier "View Xavier's Profile")**
- [![Xavier's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar4105.png)](/forum/user/4105-xavier "View Xavier's Profile")
- [ Offline](/forum/user/4105-xavier)

Less More

- Posts: 13201
- Thank you received: 2322
-
-
-
- [](http://www.kidiweb.fr)
-

12 years 4 months ago [\#158577](#158577) by [Xavier](/forum/user/4105-xavier "View Xavier's Profile")  Replied by *[Xavier](/forum/user/4105-xavier "View Xavier's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#158577 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Hi,

In the product edition page, you can add many prices on the right part, click on the add button, set the prices, then click on the save button for the product, and click on the people icon to select and restrict the price to a usergroup.
And save again.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[teamtmedia](/forum/user/39167-teamtmedia "View teamtmedia's Profile")**
- [![teamtmedia's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar39167.png)](/forum/user/39167-teamtmedia "View teamtmedia's Profile")
- [ Offline](/forum/user/39167-teamtmedia)

Less More

- Posts: 38
- Thank you received: 0
-
-
-
-

10 years 11 months ago [\#220066](#220066) by [teamtmedia](/forum/user/39167-teamtmedia "View teamtmedia's Profile")  Replied by *[teamtmedia](/forum/user/39167-teamtmedia "View teamtmedia's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#220066 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Very helpful topic, thank you. Is there also a way to display the "guest" price to "registered" users to demonstrate the savings they are getting?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

10 years 11 months ago [\#220124](#220124) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#220124 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Hi,

No, when you set an ACL on a price the price is not loaded at all if you're not part of that user group.
But you can potentially add the initial price at "retail price", or in a custom product field, or even in the description of the product.

The following user(s) said Thank You: [teamtmedia](/forum/user/39167-teamtmedia "View teamtmedia's Profile")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[proo4509](/forum/user/37936-proo4509 "View proo4509's Profile")**
- [![proo4509's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37936-proo4509 "View proo4509's Profile")
- [ Offline](/forum/user/37936-proo4509)

Less More

- Posts: 79
- Thank you received: 0
-
-

10 years 11 months ago [\#221039](#221039) by [proo4509](/forum/user/37936-proo4509 "View proo4509's Profile")  Replied by *[proo4509](/forum/user/37936-proo4509 "View proo4509's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#221039 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Hi
I've set up 2 prices for each product, each for a different ACL group.

this works, but, when I export/import my productlist, I now have 2 records for each product, which is fine, but I need to show the ACL field (for the price! not the product) to match the two prices.
There is no product-price-level field? Only a product-access field.

So, where can i find this?

(i'm working with csvimproved by the way).

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

10 years 11 months ago [\#221119](#221119) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#221119 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Hi,

I'm not sure what you mean.

I don't now how csvimproved work from the import. You should contact the support of csvimproved regarding that.

The HikaShop import has the price_access column and like the price_value column, you can use the &#124; character to separate the prices of a product.
So for example, you could have:
product_code;price_value;price_access
myproduct1;9.99&#124;8.99;,2,&#124;,3,

The users from the user group with the id 2 would see the 9.99 price and the ones from the group 3 would see 8.99 instead for that myproduct1 product.

But maybe csvimproved works differently.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[proo4509](/forum/user/37936-proo4509 "View proo4509's Profile")**
- [![proo4509's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/37936-proo4509 "View proo4509's Profile")
- [ Offline](/forum/user/37936-proo4509)

Less More

- Posts: 79
- Thank you received: 0
-
-

10 years 11 months ago [\#221128](#221128) by [proo4509](/forum/user/37936-proo4509 "View proo4509's Profile")  Replied by *[proo4509](/forum/user/37936-proo4509 "View proo4509's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#221128 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

hello, there is only a product-access group not a price-access group in the product table.

I have 2 different user groups they both see the product so they are both in the product-access group but they both see a different price. My question is, I need the product-price-acl field in my export to see something like this

product &#124; acl-prod &#124; price &#124; acl-price
000001 &#124; 2/4 &#124;12.50&#124; 4
000001 &#124; 2/4 &#124;10.50&#124; 2

I only see this now:
product &#124; acl-prod &#124; price
000001 &#124; 2/4 &#124;12.50
000001 &#124; 2/4 &#124;10.50

So the question is, how and where do I find the field that holds the product-price-access-level? It's not in de product table?

regards

Suzanne

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Away](/forum/user/63-nicolas)

Less More

- Posts: 86290
- Thank you received: 14268
-
-

10 years 11 months ago [\#221190](#221190) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[Multi Level Pricing &amp; Quickbooks Export](/forum/33-customers/868064-multi-level-pricing-quickbooks-export#221190 "-- url of the page with the problem -- :   www.netlocity.info/index.php/products  -- HikaShop version -- : HikaShop Starter: 2.3.0 -- Joomla version -- : 3.2.3 -- PHP version -- : 5.3.26 -- Browser(s) name and version -- : Firefox 29.0.1  2 Questions -  1) Is there a way to export orders to quickbooks? via CSV or by Plugin?  2) Is Multi Level Pricing Available for different groups of customers? so price would vary on login for folks on GSA Schedule vs regular consumers and businesses purchasing same product.")*

Hi,

There is no "price" column in the product table.
The columns related to the price are in the price table and are called price_value, price_access etc.
[ take.ms/OUaCe](http://take.ms/OUaCe)

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzMzLWN1c3RvbWVycy84NjgwNjQtbXVsdGktbGV2ZWwtcHJpY2luZy1xdWlja2Jvb2tzLWV4cG9ydD90bXBsPW1hcmtkb3du) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop- Install &amp; Update- Product &amp; Category Display- Content Creation- Sales and Orders- - Orders management- - Reports &amp; Statistics- Customers- Checkout- Payment Methods- Shipping Methods- Import &amp; Export (CSV, XLS…)- Specific Features- - Affilation- - Taxes- - Wishlist- - Vote- - Carousel &amp; Slider- - Mass Actions- - Filters &amp; Search- - Discount &amp; Coupon- - Feature Request- Integrations- Showcase- General Talk about HikaShop- Development- - HikaShop 3.0 Beta- Translation- Commercial Jobs HikaShop Components- HikaMarket- - Market: Feature requests- - Market: How to?- - Market: Bug Report- HikaSerial- - General talk about HikaSerial- - Serial: Bug Report- - Serial: How to?- - Support en Français de HikaSerial (French Support)- - HikaSubscription- HikaAuction- - Auction: Feature requests- - Auction: How to?- - Auction: Bug report Hikashop around the world- Support en Français (French Support)- Russian- - FAQ. Курс выживания с Hikashop. Частые вопросы и о- - Расширения Hikashop- - Наши сайты на Hikashop- 日本語版サポート(Japanese Support)- Thai- German Archives- Bug Report- How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.298 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)

[](#top)
