Xero Integration

Good Afternoon all, I am looking at trying to import all of the days order into Xero however they have specific column headings that do not match the columns exported by CS-Cart. It looks very time consuming to copy paste all the exported information into their template every day and they also ask for instance for ContactName this is a single column for | First, Last Name | where as CS-Cart exports | First Name | Last Name | as two seperate columns so importing then joining columns every time an order arrives in is exceptionally time consuming. Is anyone aware of a work around for this or maybe knows of a mapping program to map CS-Cart Field to Xero Fields?



Regards

You can do this quite easily in a spreadsheet program like excel, or Libre Office or open office. You should be able to find out by googling a bit. Then save and import.



A[color=#000000][font=Arial, Helvetica, sans-serif][size=3]ssuming, for example, your data is in cells, A1, B1, and, C1, that you want to [/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=3]concatenate[/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=3] ( arrange into a chained list ) . . . and . . . adding, in your example, the , [/size][/font][/color][color=#000000][font=Arial, Helvetica, sans-serif][size=3]between them, then . . . [/size][/font][/color]



[color=#000000][font=Arial, Helvetica, sans-serif][size=3]This can be accomplished, with either of the two methods below:



Method 1 - use the Calc CONCATENATE function . . . for instance: [/size][/font][/color]

[color=#000000][size=2]Code:[/size][/color] =CONCATENATE( A1; “,”; B1; “,”; C1 )





[color=#000000][font=Arial, Helvetica, sans-serif][size=3]Method 2 - use an & to combine the text: [/size][/font][/color]

[color=#000000][size=2]Code:[/size][/color] = A1 & “,” & B1 & “,” & C1

I have tried libra and open office and none of them offer any type of mapping. I would just love an easy way to get the data into an accounting program thats better than Quickbooks hehe.

I'm not sure what you mean. It's really quite easy to make a csv file that can be easily imported in Xero.

Just make sure the fields are filled out correcly, load it into xero, choose correct mapping and it will remember it for next time.



You can write a script or formula in any office program to merge fields for you like first and last name.

We are currently writing a full two way xero integration for CS cart it should be ready within the next 6-8 weeks.



It will be availabel via our web site http://www.4sprung.com.au

Steve I'm curious what is the difference between your cart and cs cart?

Hi Steve,



Approximate price?



@solesurvior, 4sprung is a reseller, allowed to rebrand.



J.

@jesse yea I know they are rebranding but they sell it for over 1k just assume

They must have done something major to it that differentiates it because they also sell the regular version of cscart as well.

[quote name=‘steve22’ timestamp=‘1344379451’ post=‘142428’]

We are currently writing a full two way xero integration for CS cart it should be ready within the next 6-8 weeks.



It will be availabel via our web site http://www.4sprung.com.au

[/quote]



Oh I’m very curious about that and super interested :)



Are you also doing inventory?

I'm really interested in this too. It would be a ton of help.



Thanks,



Brandon

hello Together,



After 17 years developing and running shopping carts we have spent around 3000h and have written many different addons for our whitelabbeld cs cart version some of the features are listed below:



Some of the added 4s cart functionality is



PRODUCT PERSONALISER I.E FOR GARMETS

SEO OPTIMISATION WIZZARD

DYNAMIC BANNER MANAGER FOR FRONT PAGE

VIMEO AND YOUTUBE VIDEO

MINIMUM ORDER AMOUNT PER CUSTOMER GROUP

MAIL CHIMP IMPLEMENTATION

SEO LINK HEADER

SEO CATEGORY AND CMS IMPORT EXPORT

ADVANCED PREDICTIVE SEARCH

AUTOMATIC META TAG GENERATION

AMAZON S3 IMAGE REPOSITORY

ORDER FOLLOW UP EMAIL AUTOMATISATION

SHOP ANALYTICS

FRAUD PREVENTION SUITE

GROUP BUYING DEAL FEATURE

EXTENSIVE SPEED OPTIMISATION

XERO INTEGRATION

CUSTOMISATION FEATURE

EMAIL NEWSLETTER SYSTEM

LIGHT BOX POP UP LAYER

FULL CUSTOMISABLE MEGA MENU

ULTRA FAST ONE PAGE CHECK OUT WITH AUTO COMPLETE

STORE BLOG



We have not yet set a price for the xero module but will post as soon as we know.



Best regards



Steve

Thanks for the explanation. Do you have a demo of your cart I can see in action?

Hi Steve,



Do you have a price on the Xero module as yet? v2 or v3?



Kind Regards,



James


[quote name='steve22' timestamp='1344473184' post='142496']

hello Together,



After 17 years developing and running shopping carts we have spent around 3000h and have written many different addons for our whitelabbeld cs cart version some of the features are listed below:



Some of the added 4s cart functionality is



PRODUCT PERSONALISER I.E FOR GARMETS

SEO OPTIMISATION WIZZARD

DYNAMIC BANNER MANAGER FOR FRONT PAGE

VIMEO AND YOUTUBE VIDEO

MINIMUM ORDER AMOUNT PER CUSTOMER GROUP

MAIL CHIMP IMPLEMENTATION

SEO LINK HEADER

SEO CATEGORY AND CMS IMPORT EXPORT

ADVANCED PREDICTIVE SEARCH

AUTOMATIC META TAG GENERATION

AMAZON S3 IMAGE REPOSITORY

ORDER FOLLOW UP EMAIL AUTOMATISATION

SHOP ANALYTICS

FRAUD PREVENTION SUITE

GROUP BUYING DEAL FEATURE

EXTENSIVE SPEED OPTIMISATION

XERO INTEGRATION

CUSTOMISATION FEATURE

EMAIL NEWSLETTER SYSTEM

LIGHT BOX POP UP LAYER

FULL CUSTOMISABLE MEGA MENU

ULTRA FAST ONE PAGE CHECK OUT WITH AUTO COMPLETE

STORE BLOG



We have not yet set a price for the xero module but will post as soon as we know.



Best regards



Steve

[/quote]

[color=#000000][font=tahoma, arial, verdana, sans-serif,]I'm proud to inform you that our company has released the Xero integration add-on. The retail price of this add-on is $400. Please PM me if you are interested.[/font][/color]

Our xero addon is availabel here at the monment for AU$299



availabel for 2x and 3x and within next 3 weeks also for version 4x