QuickBooks Add-on - Quickbooks Product Mapping

Quickbooks Product Mapping

Printed From: ProductCart E-Commerce Solutions
Category: ProductCart Add-on's
Forum Name: QuickBooks Add-on
Forum Description: Exchange messages with other users of the QuickBooks Add-on
URL: https://forum.productcart.com/forum_posts.asp?TID=5172
Printed Date: 19-April-2024 at 2:20pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Quickbooks Product Mapping

Posted By: GreggS
Subject: Quickbooks Product Mapping
Date Posted: 14-June-2012 at 5:11pm

The 1st time we synced up to Quickbooks worked pretty well. We have close to 5000 skus in our database. When I went to "View/ Modify Product Mappings" I noticed it didn't list all of them. It showed only 1000.

I tried finding the code that would show all the product mappings and found "QB_Constants.asp". I changed "private const scQB_PageSize=1000" to "private const scQB_PageSize=5000" and it showed all the skus (although it did take a little bit to load).

As we started adding new products through ProductCart and tried to map them, the pages no longer load. Where the skus normally load up it just says "Loading..." I tried the auto map but that won't work either. I tried changing the PageSize back to 1000 but that didn't fix anything.

I don't remember any changes to code except for the css files for styling. The only change I can think of that may affect mapping is when I would export to a csv file to make some changes and then reimport but I was told that wouldn't affect the database.

http://www.earlyimpact.com/forum/forum_posts.asp?TID=5106&title=convert-standard-item-to-bto" rel="nofollow - http://www.earlyimpact.com/forum/forum_posts.asp?TID=5106&title=convert-standard-item-to-bto

Replies:

Posted By: Matt
Date Posted: 14-June-2012 at 5:22pm

When the page size is greater than 1000 a drop down appears above the grid so you can select a range of items (e.g. like the letter groups in the phone book).

I'm not sure if your code changes broke something or if converting items from standard to BTO may have changed the product ID and invalidated the mapping.

Can you please open a ticket and provide control panel details? Once we get a good look at everything we will be able to help you out.

Posted By: GreggS
Date Posted: 19-June-2012 at 2:52pm

My boss tried it on his computer and it worked ok. He is using Firefox. I downloaded Firefox on my computer and now it loads up ok now. Not sure what setting I need to change in Internet Explorer but I think I'll just use Firefox now.

Another issue popped up where the new items in made in QuickBooks won't show up for me to map to the new items I made in ProductCart. It might be a simple thing. We're checking all our settings now. The new items we set up in Quickbooks are created as non-inventory items. I'm not sure if that is a factor.

Posted By: GreggS
Date Posted: 19-June-2012 at 3:31pm

He fixed it. Not sure what he did but it's cool.