CasperVend 2/CSV Import

External Sales Data Import

Last Updated: 24 June, 2013

DATA IS CURRENTLY IMPORTABLE FROM

• SL Transaction History (.xml file)
• XStreetSL (historical data)
• SL Marketplace (.csv)
• HippoVend (.csv)
• BSM (.csv)

WHERE TO DOWNLOAD THE SALES FILE(S)

• SL Transaction History

1) Go to: https://secondlife.com/my/account/transactions.php

2) Click "Download XML" button

3) Save the file when prompted

• XstreetSL (for historical purposes)

1) Go to: https://www.xstreetsl.com/modules.php?name=Marketplace&file=adminsales

2) Log in if necessary

3) click "View CSV Output"

4) On the new page/tab, click File > Save As (or File > Save Page As)

5) On the save window, change .php to .csv, then click "save"

• SL Marketplace:

1) Under "My Marketplace" go to: Reports > Orders

2) Change the report dates to cover all of your sales

3) Click "Go"

4) Wait for page to update

5) Click "Download CSV" link, and save when prompted

• HippoVend:

You MUST have a HippoVend vendor or product server out, "REGISTERED" with HippoVend website (use menu option) and with "ONLINE" status to continue! You don't need to have anything IN it, or products set up on the website - just a vendor or product server "registered" and in an "online" status.

1) Go to: http://www.hippo-tech-sl.com/secure/hippovend/sales.php

2) Log in

3) Click "Export to CSV" link on right side of page

4) On the new page/tab, click File > Save As (or File > Save Page As)

5) On the save window, change .php to .csv, then click "save"

• BSM (Bejambled Sales Monitor):

You may need to reactivate your account if it's currently inactive.

1) Go to https://www.bejamble.net/bsm_login.php and log in

2) Admin Menu > Import / Export > BSM Sales Data

3) This prompts you to save "MySalesExportBSM.csv"

4) Save to your hard drive

IMPORTING DATA TO CASPERVEND

1) Log in to CasperVend website

2) You should be on the Overview tab

3) Scroll down and look for the "Please use this form to upload your data" link

4) Click that

5) On the next page, browse to the location of the sales file on your hard drive

6) Click "Upload"

7) The system will digest the file and then present you with how it interpreted the data

This is the time to go over what it's showing you for accuracy!

8) If all looks good, save and continue. You will be presented with a message that the import process is complete.

The names portion of the import process will continue for a while as it resolves the name data that was sent and verifies it against actual usernames. You may see some blank or "unknown user" type entries on your statistics page while this is going on. THIS IS NORMAL and will resolve itself as names are matched up over the next several days.

9) Go back to the Overview page

10) At the top, you'll have an alert next to "3rd Party Sales Associations"

11) Click that link to go to the product wizard

12) Go through and verify each product it's showing you and make sure it is paired with the correct actual product. Change if necessary using the pulldown.

13) When you're done associating all the products, the site will give you a completion message.

14) All set!

FAQ

Q. Sometimes my statistics say "Direct Delivery" and sometimes they say "SL Marketplace" - but I don't have a MagicBox. Why does it do this?

A. As of June 2013 forward, all Marketplace data will say "SL Marketplace" for the source, regardless of whether it's a CSV upload or ANS. All old data that said "Direct Delivery" should be converted over to read "SL Marketplace" instead. This is to make it easier for the duplicate checker to reconcile actual duplicates when uploading a .csv file.