Jul 03, 2015
Mark Owen wrote
I deal with a lot of products that have combinations. I see when exporting to quickbooks takes a product with combinations and qtys of the combinations and creates a single product with one qty total.
It would be great to see the option to import these combinations into quickbooks and their own item and also ability to map/sync these combinations.
It would be great to see the option to import these combinations into quickbooks and their own item and also ability to map/sync these combinations.
New
5 votes
Vote
Reply
30 Answers
Jul 06, 2015
Alex Pryshlivskiy
agent
wrote
Thanks for comment, Mark.
From our side I'll try to discuss the ability of implementation with our development team.
From our side I'll try to discuss the ability of implementation with our development team.
Jul 06, 2015
Mark Owen
wrote
Awesome Thanks
Jul 12, 2015
System
wrote
Hello,
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
Jan 20, 2016
Randy
wrote
I have the same question. I want to clarify to make sure that the feature that I want isn't supported.
I am trying to use the Prestashop Store Manager Quickbooks addon to sync the price and quantity for product combinations. I am sync'ing from Quickbooks to Prestashop. Is this feature supported?
I am able to sync item which do not have any combinations. However, I cannot sync items with combinations. For example, I have a pencil and it comes in red, blue and green. I have a different quantity for each color.
Thanks.
I am trying to use the Prestashop Store Manager Quickbooks addon to sync the price and quantity for product combinations. I am sync'ing from Quickbooks to Prestashop. Is this feature supported?
I am able to sync item which do not have any combinations. However, I cannot sync items with combinations. For example, I have a pencil and it comes in red, blue and green. I have a different quantity for each color.
Thanks.
Jan 21, 2016
Alex Pryshlivskiy
agent
wrote
Hello !
Right now Quickbooks doesn't export product with combinations.
I'm talking about products export from Prestashop Store--- through Addon ---> Quickbooks.
AS a quick decision:
If you want to export combinations to Quickbooks- you'll be able to modify SQL query for QuickBooks Addon.
Those files are located by this path - c:\Users\___USER_NAME___\AppData\Local\eMagicOne Store Manager for PrestaShop\PluginsWorkFiles\
Files:
ExportProductsSQL_1_5.sql Multishop version 1.5 and more.
ExportProductsSQL.sql - for old versions of PrestaShop - 1.3-1.4
Right now Quickbooks doesn't export product with combinations.
I'm talking about products export from Prestashop Store--- through Addon ---> Quickbooks.
AS a quick decision:
If you want to export combinations to Quickbooks- you'll be able to modify SQL query for QuickBooks Addon.
Those files are located by this path - c:\Users\___USER_NAME___\AppData\Local\eMagicOne Store Manager for PrestaShop\PluginsWorkFiles\
Files:
ExportProductsSQL_1_5.sql Multishop version 1.5 and more.
ExportProductsSQL.sql - for old versions of PrestaShop - 1.3-1.4
Jan 21, 2016
Alex Pryshlivskiy
agent
wrote
P.S. You can order the custom SQL development if not very familiar with the DB structure and SQL syntax.
Jan 21, 2016
Randy
wrote
Thanks for the response Sergiy. My primary need is to import product quantities from Quickbook to Prestashop. My secondary need is to export orders from Prestashop to Quickbooks. It seems that these features will not work if my store is using combinations.
I am disappointed that this functionality is not supported. I am further disappointed that this information is not noted in the description for the addon. I searched for a long time to try to understand how to work with combinations with this addon but it turns out that it isn't supported. I would not have purchased this addon if it was stated that combinations are not supported.
It looks like you had some discussions about adding this feature in last year. Any decision on whether this feature my come in the future?
I am disappointed that this functionality is not supported. I am further disappointed that this information is not noted in the description for the addon. I searched for a long time to try to understand how to work with combinations with this addon but it turns out that it isn't supported. I would not have purchased this addon if it was stated that combinations are not supported.
It looks like you had some discussions about adding this feature in last year. Any decision on whether this feature my come in the future?
Jan 22, 2016
Randy
wrote
My thought on this feature would be like this:
If a combination reference exists for a product, then use the combination reference instead of product reference.
Else, use product reference.
The Quickbooks addon would then use the combination reference or product reference to match to Quickbook Item Name/Number.
I can appreciate that the actual feature will be more complicated than this but perhaps this would be a good first step which would provide enough functionality for most people.
Thanks.
If a combination reference exists for a product, then use the combination reference instead of product reference.
Else, use product reference.
The Quickbooks addon would then use the combination reference or product reference to match to Quickbook Item Name/Number.
I can appreciate that the actual feature will be more complicated than this but perhaps this would be a good first step which would provide enough functionality for most people.
Thanks.
Jan 22, 2016
Alex Pryshlivskiy
agent
wrote
Thanks for your comment.
This task was added in our to-do list.
This task was added in our to-do list.
Jan 22, 2016
Mark Owen
wrote
Hello Randy, I had the same issue. but i found a work around. It is simple, but you must keep in mind that, the quickbooks add on does not import product cost only sale price.
Here is how i accomplished this.
1. I first created all my products with combinations in prestashop.
2. I insured that the Reference# giving to the combination item in prestashop was the same I wanted as Name in QB.
3. I set up test QB company. (new company you need to make sure you create an inventory part so it creates the correct accounts needed for import later)
4. In Prestashop create an order with 1 of every part on the store
5. open store manager got to tools and click "get data from web"
6. Got to add ons and click QB Integration, This will pull up the wizard which will give you several options. (here is were the trick comes in)
7. Click Export Orders to Quickbooks.(make sure your test QB company is running) Set your export optinos to meet your needs.
8. Once you have your Export settings the way you need, complete the export.
9. Once completed you will get message that your order and inventory was exported to QB
10. When you open QB you will see all your combinations have been added.
11. once you have the inventory in QB you can then export to Excel,
12. Open you live QB company, then use the Add/Modify Multiple items.
please keep in mind Randy, that I do not push any info from QB to Prestashop, so I can not comment on how the data is transferred back to Prestashop. I assume that there should be no issues. but please test.
Hope this helps.. if you need more info one any of the steps please let me know.
Here is how i accomplished this.
1. I first created all my products with combinations in prestashop.
2. I insured that the Reference# giving to the combination item in prestashop was the same I wanted as Name in QB.
3. I set up test QB company. (new company you need to make sure you create an inventory part so it creates the correct accounts needed for import later)
4. In Prestashop create an order with 1 of every part on the store
5. open store manager got to tools and click "get data from web"
6. Got to add ons and click QB Integration, This will pull up the wizard which will give you several options. (here is were the trick comes in)
7. Click Export Orders to Quickbooks.(make sure your test QB company is running) Set your export optinos to meet your needs.
8. Once you have your Export settings the way you need, complete the export.
9. Once completed you will get message that your order and inventory was exported to QB
10. When you open QB you will see all your combinations have been added.
11. once you have the inventory in QB you can then export to Excel,
12. Open you live QB company, then use the Add/Modify Multiple items.
please keep in mind Randy, that I do not push any info from QB to Prestashop, so I can not comment on how the data is transferred back to Prestashop. I assume that there should be no issues. but please test.
Hope this helps.. if you need more info one any of the steps please let me know.
Jan 27, 2016
Randy
wrote
Thanks for the suggestion Mark. I will try it and report back.
Jan 28, 2016
Alex Pryshlivskiy
agent
wrote
Thanks for response Mark and Randy.
Please let us know. in case of failure we have plan "B" for you.
:-)
Please let us know. in case of failure we have plan "B" for you.
:-)
Feb 03, 2016
System
wrote
Hello,
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
Feb 03, 2016
Randy
wrote
Hi Mark,
Thanks a lot for taking the time to provide your instructions to me. However, it looks like that your instructions will export products (and their combinations) from Prestashop to QB. I have my products in Prestashop and QB already.
My problem is that I want to synchronize my inventory levels from QB to Prestashop. I have a physical store and online store. My physical store inventory is tracked in QB. I want to use QB as my primary system for inventory tracking. If an item is sold at my physical store, I will create an QB invoice. If I get an online order, I will also create a QB invoice. This way, QB should always have an accurate inventory count. However, I want that inventory count updated from QB to Prestashop very frequently.
The workaround that I am using right now is to export my product list from QB into Excel, then change the data into a format so it works with Store Manager. Then I import the data into Prestashop using Store Manager. I was hoping that the QB addon in Store Manager could do an inventory update with a few clicks. Instead, it takes me 15-30 minutes to do it using my workaround.
Sergiy, please let me know if you have other suggestions. I am willing to try it.
Thanks,
Randy
Thanks a lot for taking the time to provide your instructions to me. However, it looks like that your instructions will export products (and their combinations) from Prestashop to QB. I have my products in Prestashop and QB already.
My problem is that I want to synchronize my inventory levels from QB to Prestashop. I have a physical store and online store. My physical store inventory is tracked in QB. I want to use QB as my primary system for inventory tracking. If an item is sold at my physical store, I will create an QB invoice. If I get an online order, I will also create a QB invoice. This way, QB should always have an accurate inventory count. However, I want that inventory count updated from QB to Prestashop very frequently.
The workaround that I am using right now is to export my product list from QB into Excel, then change the data into a format so it works with Store Manager. Then I import the data into Prestashop using Store Manager. I was hoping that the QB addon in Store Manager could do an inventory update with a few clicks. Instead, it takes me 15-30 minutes to do it using my workaround.
Sergiy, please let me know if you have other suggestions. I am willing to try it.
Thanks,
Randy
Feb 04, 2016
Alex Pryshlivskiy
agent
wrote
Quick correction for you:
Here it is zip archive with SQL query
1/ Close Store Manager.
2/ Please download and replace it by the following path - c:\Users\%USERNAME%\AppData\Local\eMagicOne Store Manager for PrestaShop\PluginsWorkFiles\
3/ Start Store Manager again
Please try.
Here it is zip archive with SQL query
1/ Close Store Manager.
2/ Please download and replace it by the following path - c:\Users\%USERNAME%\AppData\Local\eMagicOne Store Manager for PrestaShop\PluginsWorkFiles\
3/ Start Store Manager again
Please try.
Feb 04, 2016
Alex Pryshlivskiy
agent
wrote
P.S. Don't forget to backup whole folder just in case :-)
Feb 04, 2016
Randy
wrote
HI Sergiy,
Thanks for the response. Could you tell me what the SQL query is going to do? I just want to understand it a bit better.
Thanks,
Randy
Thanks for the response. Could you tell me what the SQL query is going to do? I just want to understand it a bit better.
Thanks,
Randy
Feb 08, 2016
Alex Pryshlivskiy
agent
wrote
Hello Randy
with this SQL you'll be able to transfer products combinations to QuickBooks. Not products in order - only combinations.
with this SQL you'll be able to transfer products combinations to QuickBooks. Not products in order - only combinations.
Feb 09, 2016
Randy
wrote
Thanks Sergiy.
As I mentioned earlier, I already have all my product combinations in Quickbooks. I am looking for a way to sync the inventory from QB to Prestashop. It seems like this SQL will not help me do that.
As I mentioned earlier, I already have all my product combinations in Quickbooks. I am looking for a way to sync the inventory from QB to Prestashop. It seems like this SQL will not help me do that.
Feb 10, 2016
Alex Pryshlivskiy
agent
wrote
Do you need to sync. q-ty and price for combinations? Am I right ? please confirm
Feb 10, 2016
Alex Pryshlivskiy
agent
wrote
Right now you can export prece and qty for products - https://www.prestashopmanager.com/prestashop-quickbooks-integration/
Import products from QuickBooks to Store Manager
- create new Products
- update Stock/Price
- optionally update Name, Price, Quantity and Description
Work with combination in our future plans.
Import products from QuickBooks to Store Manager
- create new Products
- update Stock/Price
- optionally update Name, Price, Quantity and Description
Work with combination in our future plans.
Feb 12, 2016
Randy
wrote
Hi Sergiy,
Yes, I want to sync quantity and price for combinations from Quickbooks to Prestashop. Do you have any timetable on when this feature might be added? I am eager to have this feature. I am willing to help test if there is a beta version of this feature available.
Thanks,
Randy
Yes, I want to sync quantity and price for combinations from Quickbooks to Prestashop. Do you have any timetable on when this feature might be added? I am eager to have this feature. I am willing to help test if there is a beta version of this feature available.
Thanks,
Randy
Feb 12, 2016
Alex Pryshlivskiy
agent
wrote
Hello Randy,
Right now we are working on eBay Addon and Amazon Addon.
It's reasonable to return to QuickBooks after 2 Addons Release.
I guess it will be closer to April.
Thanks for beta-testing - I'll reach you via email and provide Beta-version.
Right now we are working on eBay Addon and Amazon Addon.
It's reasonable to return to QuickBooks after 2 Addons Release.
I guess it will be closer to April.
Thanks for beta-testing - I'll reach you via email and provide Beta-version.
Feb 17, 2016
System
wrote
Hello,
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
Feb 20, 2016
AJ Quick
wrote
I created an account just so I could comment on this. This is exactly what I need too! I was ready to shell out money for a couple of Store Manager licenses and the Quickbooks Integration license. I just need to know if the Combinations I import from Prestashop to Quickbooks are treated as individual items?
Each combination has a SKU / Reference and should be treated in Quickbooks as an item.
Likewise, if I import products from Quickbooks (to update quantities) will those items in Quickbooks be correctly mapped to the combinations in Prestashop?
Each combination has a SKU / Reference and should be treated in Quickbooks as an item.
Likewise, if I import products from Quickbooks (to update quantities) will those items in Quickbooks be correctly mapped to the combinations in Prestashop?
Feb 20, 2016
AJ Quick
wrote
I should add, that products should be imported into Quickbooks as items. Combinations should 'probably' be imported as subitems to the parent item.
Feb 22, 2016
Alex Pryshlivskiy
agent
wrote
Each combination in this case separate item.
Could you provide your csv file? We'll have a look.
Could you provide your csv file? We'll have a look.
Feb 25, 2016
AJ Quick
wrote
I don't have a CSV. Not sure where I would get that from. But one thing we would definitely need is the ability to import from Quickbooks and have it be assigned to combination items. For example we might have an item in our Quickbooks that is a combination in Prestashop. Updating the quantity in Quickbooks, would need to also update the combination quantity in Prestashop.
Feb 26, 2016
Alex Pryshlivskiy
agent
wrote
Right now, this custom SQL is quick decision for current version of QuickBooks Addon.
Implementation of combination export in our future plans for Addon.
Implementation of combination export in our future plans for Addon.
Mar 02, 2016
System
wrote
Hello,
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team
We haven't heard back from you for last 5 days, please confirm that all questions were answered and issues are resolved. In case you haven't received an answer, please check your spam folder or check the status of ticket online at:
https://support.emagicone.com
Maybe we are waiting for some information from your side? In this case please get back to us.
In case we haven't replied you back or in case of any misunderstanding, please reply to this mail with all details so we could proceed.
If you do not reply us back, the ticket will be automatically closed within 24 hours.
With kind regards,
The eMagicOne Administration Team