PDA

View Full Version : Affiliate Sales Data - upload spreadsheets - membership


17th December 2004, 11:12 PM
Hi All

I'm looking for a way to allow sales affiliates to upload spreadsheets of sales and customer data.

I want to make it easy to consolidate all affiliate sales data so that orders can be processed as smoothly as possible.

Can your affiliate system do the following?

1. convert .xls files (and others) into tab-delimited files (cuz I really don't want .xls files uploaded)

2. perhaps provide validation of data (like check for unauthorized characters, word filter, and other such things

3. have some kind of membership control, like password-protected access

The idea is that we would be providing a fulfillment service and have lots of affiliates gathering their own sales data, converting it into a flatfile.

Yes, I know that the affiliates could simply email a spreadsheet, but email gets to be a bit cumbersome and time-consuming. Instead, it would be great to have a sort of affiliate control center and snag it all in one shot.

Thanks very much :)