Quickbooks Order Transfer Error

General ShopSite user discussion

Quickbooks Order Transfer Error

Postby dlundell » Sun Feb 11, 2007 8:00 pm

I'm using Order Transfer utility (version 1.7)
and am getting errors on certain records.

An example error is:

**** Sun 11 Feb 2007 14:15 ****

5616Tue 09 Feb 2007 06:02Firstname Lastname
String too long.
(0x80040304)

Anyone know if this is a known problem, and if so if it's been
fixed? (Is there a newer version of the utility available?)

Thanks,

- dc
dlundell
 
Posts: 95
Joined: Fri Aug 04, 2006 6:13 pm

"Name" too long

Postby LisaMcCormick » Fri Jul 02, 2010 3:24 pm

I am having a similar problem. Error code (3070) product "Name" field too long, something something, string something. It is very frustrating. I'm trying to play with the settings in both the order transfer properties, and the properties in QB.
LisaMcCormick
 
Posts: 2
Joined: Fri Jul 02, 2010 3:15 pm
Location: Santa Cruz, CA

Postby loren_d_c » Fri Jul 02, 2010 3:39 pm

Do you have SKU's assigned to your ShopSite products? If so, how long are they? If you don't have SKU's, how long are your product Names?

QuickBooks has a limit of 13 characters for its item names. If you have your Order Transfer configured to create new items in QuickBooks if the products in the ShopSite order don't already exist in QuickBooks, then you may get this error if the SKU (or product name, if you don't have an SKU) is longer than 13 characters, because this is all QuickBooks will allow. A solution to avoid this on future orders is to assign SKUs to all of your ShopSite products (so you don't have to shorten the product Name itself) and make sure the SKUs are 13 characters or less in length.

-Loren
loren_d_c
 
Posts: 2572
Joined: Fri Aug 04, 2006 12:02 pm
Location: Anywhere

SKU fix

Postby LisaMcCormick » Fri Jul 02, 2010 8:55 pm

Awesome! Thank you. I didn't have a SKU assigned to the product that was giving me trouble. I will add one and try it again on Tuesday.
LisaMcCormick
 
Posts: 2
Joined: Fri Jul 02, 2010 3:15 pm
Location: Santa Cruz, CA


Return to User Forum

Who is online

Users browsing this forum: No registered users and 25 guests