X-Cart: shopping cart software

X-Cart forums (https://forum.x-cart.com/index.php)
-   Dev Questions (https://forum.x-cart.com/forumdisplay.php?f=20)
-   -   QuickBooks 2005 (https://forum.x-cart.com/showthread.php?t=17365)

a.harris 10-18-2005 09:15 AM

QuickBooks 2005
 
Having struggled with QuickBooks 2005 integration, getting the IIF to be formated properly; we have modified the

Code:

skin1/modules/QuickBooks/orders_export_qb.tpl

file to be what we think is in line with the required specifications:

Enjoy :)

Code:

{* $Id: orders_export_qb.tpl,v 1.13.2.7 2005/03/09 12:58:05 mclap Exp $ *}
!ACCNT{$delimiter}NAME{$delimiter}ACCNTTYPE{$delimiter}SCD{$delimiter}EXTRA{$delimiter}HIDDEN
{* Define account for taxes. Please don't change ACCNTTYPE & EXTRA fields for it! It must be an income account. *}
ACCNT{$delimiter}{$config.QuickBooks.acct_tax}{$delimiter}INC{$delimiter}{$delimiter}{$delimiter}N

{assign var="have_processed" value=""}

!CUST{$delimiter}NAME{$delimiter}BADDR1{$delimiter}BADDR2{$delimiter}BADDR3{$delimiter}BADDR4{$delimiter}BADDR5{$delimiter}SADDR1{$delimiter}SADDR2{$delimiter}SADDR3{$delimiter}SADDR4{$delimiter}SADDR5{$delimiter}PHONE1{$delimiter}FAXNUM{$delimiter}EMAIL{$delimiter}CONT1{$delimiter}SALUTATION{$delimiter}COMPANYNAME{$delimiter}FIRSTNAME{$delimiter}LASTNAME{$delimiter}CUSTFLD1

{section name=oid loop=$orders}
CUST{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$orders[oid].b_firstname} {$orders[oid].b_lastname}{$delimiter}{$orders[oid].b_address} {$orders[oid].b_address_2}{$delimiter}"{$orders[oid].b_city}, {$orders[oid].b_state} {$orders[oid].b_zipcode}"{$delimiter}{$orders[oid].b_countryname}{$delimiter}{$delimiter}{$orders[oid].s_firstname} {$orders[oid].s_lastname}{$delimiter}{$orders[oid].s_address} {$orders[oid].s_address_2}{$delimiter}"{$orders[oid].s_city}, {$orders[oid].s_state} {$orders[oid].s_zipcode}"{$delimiter}{$orders[oid].s_countryname}{$delimiter}{$delimiter}{$orders[oid].phone}{$delimiter}{$orders[oid].fax}{$delimiter}{$orders[oid].email}{$delimiter}{$orders[oid].lastname}, {$orders[oid].b_firstname}{$delimiter}{$orders[oid].title}{$delimiter}{$orders[oid].company}{$delimiter}{$orders[oid].firstname}{$delimiter}{$orders[oid].lastname}{$delimiter}{$orders[oid].login}
{/section}

!TRNS{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}{$delimiter}CLASS{$delimiter}AMOUNT{$delimiter}DOCNUM{$delimiter}MEMO{$delimiter}ADDR1{$delimiter}ADDR2{$delimiter}ADDR3{$delimiter}ADDR4{$delimiter}ADDR5{$delimiter}SHIPVIA{$delimiter}SADDR1{$delimiter}SADDR2{$delimiter}SADDR3{$delimiter}SADDR4{$delimiter}SADDR5{$delimiter}TOPRINT

!SPL{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}{$delimiter}CLASS{$delimiter}AMOUNT{$delimiter}DOCNUM{$delimiter}MEMO{$delimiter}PRICE{$delimiter}QNTY{$delimiter}INVITEM{$delimiter}TAXABLE{$delimiter}EXTRA
!ENDTRNS       

{if $config.QuickBooks.export_invitems eq "Y"}
{* Declare invetory items *}
!INVITEM{$delimiter}NAME{$delimiter}INVITEMTYPE{$delimiter}DESC{$delimiter}PURCHASEDESC{$delimiter}ACCNT{$delimiter}PRICE{$delimiter}COST{$delimiter}TAXABLE{$delimiter}REORDERPOINT{$delimiter}ASSETACCNT{$delimiter}COGSACCNT
{section name=oid loop=$orders}
{if $orders[oid].gcid}{* INVITEM:GIFT CERTIFICATE *}
INVITEM{$delimiter}GIFT CERTIFICATE{$delimiter}INVENTORY{$delimiter}GC#{$orders[oid].gcid}{$delimiter}GC#{$orders[oid].gcid}{$delimiter}{$config.QuickBooks.acct_gc}{$delimiter}{$orders[oid].amount}{$delimiter}0{$delimiter}N{$delimiter}0{$delimiter}{$config.QuickBooks.acct_inv_asset}{$delimiter}{$config.QuickBooks.acct_inv_cogs}
{else}{* INVITEM:PRODUCT *}
{if $orders[oid].productcode ne ""}{assign var="invitem_name" value=$orders[oid].productcode}
{else}{assign var="invitem_name" value=$orders[oid].productid}
{/if}
INVITEM{$delimiter}{$invitem_name}{$delimiter}INVENTORY{$delimiter}{$orders[oid].product}{if $orders[oid].product_options ne ""}\n{$orders[oid].product_options}{/if}{$delimiter}{$orders[oid].product}{if $orders[oid].product_options ne ""}\n{$orders[oid].product_options}{/if}{$delimiter}{$config.QuickBooks.acct_product}{$delimiter}{$orders[oid].price}{$delimiter}0{$delimiter}N{$delimiter}{$config.QuickBooks.qb_reporderpoint}{$delimiter}{$config.QuickBooks.acct_inv_asset}{$delimiter}{$config.QuickBooks.acct_inv_cogs}
{/if}
{/section}
{/if}{* $config.QuickBooks.export_invitems eq "Y" *}

{assign var="new_order" value=""}
{section name=oid loop=$orders}
{if $orders[oid].total gt 0}
{assign var="order_total" value=$orders[oid].total}
{else}
{math equation="x+y" x=$orders[oid].total y=$orders[oid].giftcert_discount assign="order_total"}
{/if}

{if $new_order ne $orders[oid].orderid}{* start new order *}
{if $new_order ne ""}
{* make qb happy *}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_tax}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}0{$delimiter}{$orders[oid].orderid}{$delimiter}TAX{$delimiter}{$delimiter}{$delimiter}{$delimiter}N{$delimiter}AUTOSTAX
ENDTRNS
{/if}
{assign var="new_order" value=$orders[oid].orderid}
TRNS{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}HSBC{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$order_total}{$delimiter}{$orders[oid].orderid}{$delimiter}Website Order: {$orders[oid].details|replace:"\r":" "|replace:"\n":" "|replace:"\t":" "}{$delimiter}{$orders[oid].b_firstname} {$orders[oid].b_lastname}{$delimiter}{$orders[oid].b_address} {$orders[oid].b_address_2}{$delimiter}"{$orders[oid].b_city}, {$orders[oid].b_state} {$orders[oid].b_zipcode}"{$delimiter}{$orders[oid].b_countryname}{$delimiter}{$delimiter}{$delimiter}{$orders[oid].s_firstname} {$orders[oid].s_lastname}{$delimiter}{$orders[oid].s_address} {$orders[oid].s_address_2}{$delimiter}"{$orders[oid].s_city}, {$orders[oid].s_state} {$orders[oid].s_zipcode}"{$delimiter}{$orders[oid].s_countryname}{$delimiter}{$delimiter}Y

{* start new order *}
{if $orders[oid].gcid}{* CASH SALE:GIFT CERTIFICATE *}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_gc}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$orders[oid].amount}{$delimiter}{$orders[oid].orderid}{$delimiter}GC#{$orders[oid].gcid}{$delimiter}{$orders[oid].amount}{$delimiter}-1{$delimiter}GIFT CERTIFICATE{$delimiter}N{$delimiter}
{else}{* CASH SALE:PRODUCT *}
{if $orders[oid].productcode ne ""}{assign var="invitem_name" value=$orders[oid].productcode}
{else}{assign var="invitem_name" value=$orders[oid].productid}
{/if}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_product}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$orders[oid].cost}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].product}{if $orders[oid].product_options ne ""}\n{$orders[oid].product_options}{/if}{$delimiter}{$orders[oid].price}{$delimiter}-{$orders[oid].amount}{$delimiter}{*$invitem_name*}TFT Non Stock{$delimiter}N{$delimiter}
{/if}
{if $orders[oid].total gt 0 and $orders[oid].giftcert_discount gt 0}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_gc_discount}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$orders[oid].giftcert_discount}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].applied_giftcerts}{$delimiter}-{$orders[oid].giftcert_discount}{$delimiter}-1{$delimiter}GIFT CERTIFICATE(s){$delimiter}N{$delimiter}
{/if}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_shipping}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$orders[oid].shipping_cost}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].shipping|trademark}{$delimiter}{$orders[oid].shipping_cost}{$delimiter}-1{$delimiter}Shipping{$delimiter}N{$delimiter}
{if $orders[oid].coupon_discount gt 0}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_coupon_discount}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$orders[oid].coupon_discount}{$delimiter}{$orders[oid].orderid}{$delimiter}{$orders[oid].coupon}{$delimiter}-{$orders[oid].coupon_discount}{$delimiter}-1{$delimiter}COUPON DISCOUNT{$delimiter}N{$delimiter}
{/if}
{if $orders[oid].discount gt 0}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}{$config.QuickBooks.acct_discount}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}{$orders[oid].discount}{$delimiter}{$orders[oid].orderid}{$delimiter}DISCOUNT{$delimiter}-{$orders[oid].discount}{$delimiter}-1{$delimiter}DISCOUNT{$delimiter}N{$delimiter}
{/if}
{foreach key=tax_name item=tax from=$orders[oid].tax_values}
{if $tax.tax_cost gt 0}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}VAT Control{*$config.QuickBooks.acct_tax*}{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}-{$tax.tax_cost}{$delimiter}{$orders[oid].orderid}{$delimiter}{$tax.tax_display_name} {$tax.rate_type}{$tax.rate_value}{$delimiter}{$vat_value}{$delimiter}-1{$delimiter}TAX{$delimiter}N{$delimiter}
{/if}
{/foreach}
{/if}
{if %oid.last%}
{* make qb happy *}
SPL{$delimiter}CASH SALE{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}VAT Control{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$config.QuickBooks.trans_class}{$delimiter}0{$delimiter}{$orders[oid].orderid}{$delimiter}TAX{$delimiter}{$delimiter}{$delimiter}{$delimiter}N{$delimiter}AUTOSTAX

ENDTRNS
{/if}
{/section}

{if $config.QuickBooks.qb_exportpayments eq "Y"}
!TRNS{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}NAME{$delimiter}AMOUNT{$delimiter}PAYMETH{$delimiter}DOCNUM
!SPL{$delimiter}TRNSTYPE{$delimiter}DATE{$delimiter}ACCNT{$delimiter}NAME{$delimiter}AMOUNT{$delimiter}DOCNUM
!ENDTRNS

{assign var="new_order" value=""}
{section name=oid loop=$orders}
{if $orders[oid].status eq "P"}
{if $orders[oid].total gt 0}
{assign var="order_total" value=$orders[oid].total}
{else}
{math equation="x+y" x=$orders[oid].total y=$orders[oid].giftcert_discount assign="order_total"}
{/if}
{if $new_order ne $orders[oid].orderid}{* start new order *}
{if $new_order ne ""}
ENDTRNS
{/if}
{assign var="new_order" value=$orders[oid].orderid}
TRNS{$delimiter}PAYMENT{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}Undeposited Funds{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}{$order_total}{$delimiter}{$orders[oid].payment_method}{$delimiter}{$orders[oid].orderid}
SPL{$delimiter}PAYMENT{$delimiter}{$orders[oid].date|date_format:"%m/%d/%Y"}{$delimiter}HSBC{$delimiter}{$orders[oid].b_lastname}, {$orders[oid].b_firstname} - {$orders[oid].login}{$delimiter}-{$order_total}{$delimiter}{$orders[oid].orderid}
{if %oid.last%}
ENDTRNS
{/if}
{/if}{* start new order *}
{/if}
{/section}
{/if}{* $config.QuickBooks.qb_exportpayments eq "Y" *}


extremeis 10-20-2005 12:20 PM

Hello,

Does this modification import the credit card info found in the note field to the payment info area within QB2005?

I have a client who has been struggling with this as they process all orders through quickbooks.

Ryan

elviselviselvis 11-10-2005 07:04 AM

A.harris
I too am modifying the export file for quicken, but would like to do the following:
We have prepaid certificates that people can buy for themselves or a freind so these types of sales on the system need to come into Quickbooks as a liability.
Also since we are in US we need the taxes collected to come into the quickbooks as a tax payable liability -- currently the default quickbook .tpl file has them imported into sales.
IF you get any feed back or help with your issues please post and i will post anything i find on this matter also
Cheers!
Sam :)

delphi 12-27-2005 08:44 AM

Re: QuickBooks 2005
 
Anyone with luck on running IFF for Quickbook 2005?

I used the code above and when I imported, everything is okay but it does not show any transaction in Quickbook.

Is there anything that I am missing?

elviselviselvis 12-27-2005 09:43 AM

Delphi,
I have the same problem.

I get the customer data to import but the sales comes in as Invoice, nothing in the deposit of the check register.
I dont have enough information on how to format the file so that all the proper fields in Quickbooks gets data...... But will post any updates to my search and trials... here...


Sam

delphi 12-27-2005 10:34 AM

Thanks,

I've been using Quickbook 2003 and all import/export are fine. Until recently we upgraded to Quickbook 2005 Pro and the IIF export is not mapping anymore.

really need some expert help here

SoapLady 01-02-2006 09:27 AM

QB 2006
 
I just upgraded to QB 2006.

Does anyone have experience with X-Cart into QB2006 or know if the QB2005 specs will work for importing into QB2006?

shipmerchant 01-31-2006 11:53 AM

I opened a ticket with Xcart and the reply was that they can only gurantee export to QB for sure with QB02/QB03. Thats the information I have recieved
which was rather disapointing, but hopefully they will get on this soon, as I dont of too many people who would use such an outdated program.

Lets stay tuned. :cry:

SoapLady 02-01-2006 06:59 PM

Quickbooks
 
Thanks.

I expect that it will become important at some point!

shipmerchant 02-03-2006 06:44 PM

Well I just tried the export from the store and imported the .IFF file into QBPremier 06 and all seems to be fine. We only use PayPal at this point in our venture so every transaction comes in as invoice even though its been processed. So I think it will require some modifications to correct it, but other than that, all seems to be working for now.

I am just amazed that there is little if no support on this from Xcart, but then again QB is another parties application.

BTW this was all done without applying any mods at this point all was set as default. We plan to meet with our accountant sometime soon to see if they can recomend any changes we would need to make sure QB is getting all the necessary information in the stores export, then move on from there.

#-o


All times are GMT -8. The time now is 09:46 PM.

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.