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