View previous topic :: View next topic |
Author |
Message |
mgladding
Joined: 31 May 2009 Posts: 5
|
Posted: Tue Jul 14, 2009 12:46 pm Post subject: Importing Sales data from FastSpring |
|
|
I'm trying to import sales data from the FastSpring Site Line Item CSV export file.
The import works correctly except for orders that contain multiple items. In this case only the first item is imported.
I'm using the following import definition, modified slightly from that submitted by a previous poster to this forum.
Code: |
<Importer xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="CsvSalesImporter">
<DateFormat>
<string>M/d/yy</string>
</DateFormat>
<PurchaseTag>row</PurchaseTag>
<PurchaseReferenceTag>Reference</PurchaseReferenceTag>
<PurchaseDateTag>Date</PurchaseDateTag>
<SalutationTag>Salutation</SalutationTag>
<LastNameTag>Last_x0020_Name</LastNameTag>
<FirstNameTag>First_x0020_Name</FirstNameTag>
<CompanyTag>Company</CompanyTag>
<EmailTag>Email</EmailTag>
<PhoneTag>Phone</PhoneTag>
<FaxTag></FaxTag>
<Street1Tag>Address_x0020_1</Street1Tag>
<StateTag>Region</StateTag>
<CityTag>City</CityTag>
<ZipTag>Postal</ZipTag>
<CountryTag>Country</CountryTag>
<ProductReferenceTag>Product</ProductReferenceTag>
<QuantityTag>Quantity</QuantityTag>
<TotalPriceTag>Subtotal</TotalPriceTag>
<LicenseKeyTag>Licenses</LicenseKeyTag>
<LicenseKeyDelimiter>\n</LicenseKeyDelimiter>
</Importer>
|
|
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Tue Jul 14, 2009 11:04 pm Post subject: |
|
|
How do Fastspring handle multiple purchase items for a customer? Do they just add an extra line? If you could email a sample of the format for multiple purchase items to support@infralution.com we will take a look. _________________ Infralution Support |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Wed Jul 15, 2009 11:13 pm Post subject: |
|
|
Thanks for the sample CSV file. I created a database with products to match the products defined in your CSV file and then just changed the license keys in the CSV file to ones I generated (so I could import them). I used your import definition for the distributor – but had to modify it slightly because your CSV file contains dates in two different formats. I was then able to import the CSV file without issues and it created sales for each line item (which you can see when you expand the customer or look in the Sales tab).
I’ve sent you a copy of the database where I have defined the product and the distributor (including modified import definition) as well as the modified CSV file (with license keys) so that you can try importing the CSV yourself. _________________ Infralution Support |
|
Back to top |
|
|
scdavid
Joined: 14 Feb 2011 Posts: 6
|
Posted: Mon Feb 14, 2011 6:40 pm Post subject: |
|
|
Do you formally support FastSpring? I don't see it in the templates folder. |
|
Back to top |
|
|
Infralution
Joined: 28 Feb 2005 Posts: 5027
|
Posted: Mon Feb 14, 2011 11:37 pm Post subject: |
|
|
We don't include a FastSpring import definition in the ILS install - but we are happy to support you if you want to use it. Here is the import definition that worked for the original poster:
Code: | <Importer xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="CsvSalesImporter">
<DateFormat>
<string>M/dd/yy</string>
<string>M/dd/yyyy</string>
</DateFormat>
<PurchaseTag>row</PurchaseTag>
<PurchaseReferenceTag>Reference</PurchaseReferenceTag>
<PurchaseDateTag>Date</PurchaseDateTag>
<SalutationTag>Salutation</SalutationTag>
<LastNameTag>Last_x0020_Name</LastNameTag>
<FirstNameTag>First_x0020_Name</FirstNameTag>
<CompanyTag>Company</CompanyTag>
<EmailTag>Email</EmailTag>
<PhoneTag>Phone</PhoneTag>
<FaxTag></FaxTag>
<Street1Tag>Address_x0020_1</Street1Tag>
<StateTag>Region</StateTag>
<CityTag>City</CityTag>
<ZipTag>Postal</ZipTag>
<CountryTag>Country</CountryTag>
<ProductReferenceTag>Product</ProductReferenceTag>
<QuantityTag>Quantity</QuantityTag>
<TotalPriceTag>Subtotal</TotalPriceTag>
<LicenseKeyTag>Licenses</LicenseKeyTag>
<LicenseKeyDelimiter>\n</LicenseKeyDelimiter>
</Importer> |
_________________ Infralution Support |
|
Back to top |
|
|
|