The email address to contact them is firstname.lastname@example.org (UK Affiliates, use this email instead: email@example.com). I think there is only one person at Linkshare US (and probably UK too) who takes care of such requests; I've always gotten a response from Kalia.
To make it easy for Linkshare to get the feed enabled, provide the merchant's MID (you can find the MID in the Excel file of the merchants that have feeds) and, if you happen to know it, your SID.
Also note that the FTP access is connected to a marketing channel. If you have multiple channels, multiple merchandiser FTP accounts will be necessary. If you don't know your SID, provide the LS Merchandiser Service Department with everything you do know or can find on the website that helps the department know what to enable:
1 If you have multiple channels and don't know which one is enabled, make a list of each channel and connected programs that are approved for each channel and ask Linkshare as well.
2 The link ID is the 10-character value for the URL parameter "ID" in your affiliate links (http://click.linksynergy.com/fs-bin/click?id=XxXxXxXxXx&offerid=666666.88888888&type=1&subid=1)
Take the opportunity to ask what your merchandiser-enabled SID is = Login/Marketing Channel = Link ID = FTP or Merchandiser Account.
You will also be able to see it once you have the FTP access working.
Just for the case they don't answer your question or if you forget it. You don't need to shoot them a separate email because of it.
The advertiser wants to specifically approve/deny which affiliates can gain access to the feed. If your request requires second approval, the LS Merchandiser Service Department will send a request to the advertiser asking for permission.
That can take forever. I recommend sending the advertiser an email at the same time you request access to it from the LS Merchandiser Service Department, so that the advertiser knows what to look for on your behalf. You also get the chance to tell the merchant what you want to do with the feed and introduce yourself (if you have not yet had direct contact with the affiliate manager). This avoids or at least reduces the chance that your request for access will be denied.
Keep track of your requests, the dates you contact the LS Merchandiser Service Department, the dates you contact the merchant, and what the status of each request is. I created an Excel file and even sent it to the LS Merchandiser Service Department with every request as reference (so they can see what else is still pending somewhere in the process).
Subject: New Feeds Request - SID: 666666 - MID: 926 - Office Depot
Hello Merchandiser Service (Kalia),
Please enable access to the Office Depot Datafeed (MID: 926).
Our SID is: 666666
Attached is the current status of all our LS datafeeds and datafeed requests.
Your Name and Contact Information
Part of the process of getting you up and running, using the FTP account of the LS Merchandiser Service Department, is to provide Linkshare with the IP address of the machine (server) that connects via FTP client to the Linkshare FTP server.
Crucial to this process is that you have a machine with a static IP address - that is, one that does not change. A dedicated or co-located server would be the best, or a DSL account where you pay a little bit extra to get a static IP address. Regular cable or DSL accounts usually do not have a static IP address and cannot be used (unless Linkshare does not mind changing your account over and over again when your IP changes). However, this will result in days during which you will have no access to fresh datafeeds.
I am not 100% sure, but I believe that Linkshare also allows the specification of an IP range (if it is not too broad). If that is the case, then you also need to provide what is called the "subnet mask." The subnet mask is always 255.255.255.0 for a static IP; because it doesn't change with a static IP, nobody asks for it if a static IP address is provided. The subnet mask might be different if you provide a range of IPs.
Note 7/2007: I was doing a test from another computer with an IP address that was never registered with Linkshare. It was working, which means that Linkshare does currently not check the IP. This might change any day. Because of this, make sure that you do the steps correctly to avoid being blocked from accessing your feeds one day, if Linkshare actually checks the IP of incoming requests.
If you can't ask the provider or if there is no provider and only a non-responsive IT department that leaves your server problems unaddressed, here is a way to find the IP of the machine you want to use for FTP access.
Is your server a Windows server? Select "start" and "run" and enter "cmd" into the textbox. Then hit enter. It should open a DOS Window with a blinking white prompt on a black background.
Type: "ipconfig" at the system command prompt. It should return the Windows IP configuration where you can see your IP address.
If your server has multiple network cards, a bunch of stuff will come back. If you are not sure which one is the one that actually connects to the Internet, you will need to contact your IT department.
If the IP address starts with "192.168.xxx.xxx" you are within an internal network and probably behind a firewall as well. You will need to contact your department IT in that case.
To find the IP of your host, you must use the command 'ifconfig'.
It is usually found in the /sbin directory. At the prompt type:
[admin@plain admin]$ /sbin/ifconfig
and you will get a response like:
eth0 Link encap:Ethernet HWaddr 00:C0:A8:FD:10:A9
inet addr:220.127.116.11 Bcast:18.104.22.168 Mask:255.255.254.0
UP BROADCAST RUNNING PROMISC MULTICAST MTU:1500 Metric:1
RX packets:105476284 errors:0 dropped:0 overruns:6 frame:0
TX packets:47008808 errors:0 dropped:0 overruns:0 carrier:0
The second line contains the desired information. (Here I have replaced the real values with fake information.)
inet addr: is your host's ip address i.e. 22.214.171.124
Bcast: is the Broadcast address i.e. 126.96.36.199
Mask: is the Net Mask for you host i.e. 255.255.254.0
The standard "port" used for FTP is "21", which is different from the regular web "http://" port, which is "80" or "443" for the "https://" secured transmission.
It is not uncommon that port 21 is by default blocked for incoming and/or outgoing traffic. If everything else seems to be set up correctly, and it still does not work, this might be the issue.
Your IT department needs to change the configuration of its firewall to "open the port" for traffic between the IP address of the Linkshare FTP server and your server where the FTP client is running.
You know your machine's IP, because you provided that information to Linkshare. Linkshare's IP is simple to find. Resolve the IP for the FTP address "aftp.linksynergy.com". At the time I was writing this, the IP address was: 188.8.131.52 (check current IP).
The FTP commands I am providing here will work for Windows servers, but might not work on Linux or Unix machines. Open a DOS Window again (explained in a previous section).
1) Enter "ftp" at the prompt, the DOS FTP client from Windows gets started which is also command prompt controlled.
2) Type "lcd" to set the local download directory on the server, example: "lcd c:\temp".
3) Connect to the Linkshare FTP, type: "open aftp.linksynergy.com". It will prompt you to enter your username and password. Enter what was provided to you by Linkshare.
(When you enter the password, no characters are displayed on the screen, which might be a bit confusing.)
If you get disconnected at this point, either the username or password are incorrect or the IP from which you are connecting is not registered with Linkshare. You have to get that clarified first. Type: "quit" to exit the FTP client. Now it is time to get in contact with your IT department or ISP provider to find out which IP you are using, and if it matches what Linkshare has enabled for your account.
4) Type: "dir" to retrieve the list of files available on the FTP. It should return a list that looks similar to this:
-rw-rwxr-- 1 root 65533 0 Jul 30 04:08 926 666666 mp.txt.gz.lmp
-rw-rwxr-- 1 root 65533 0 Jul 30 04:08 926 666666 mp.xml.gz.lmp
926 is the MID of Office Depot which I use as an example. 666666 is your SID.
Two files should exist for each MID:
926 666666 mp.txt.gz.lmp
926 666666 mp.xml.gz.lmp
The ".txt.gz" is the feed in text, pipe delimited format and "xml.gz" is the feed in XML format. Ignore the fact that the files on the server are 0 byte in size and also ignore the extension ".lmp".
5) Write down the file names of the feeds you want to download.
6) Type: "binary"1
1This tells the FTP that you want to retrieve binary data. It is usually not necessary to enter, but it avoids possible issues and does not hurt.
Replace 666666 with your SID and 926 with the MID of the merchant whose feed you want to download. Don't enter the ".lmp" extension.
The files should download and be saved in the folder you have specified earlier. Wait for the download to finish. The length of time it takes depends on the size of the feed and your connection speed.
Enter "quit" to leave the FTP client.
At the prompt, type:
[admin@plain admin]$ ftp
dir or ls
bi or binary
This is a pretty cumbersome process to go through every time you want to get a new version of the file.
It can be scripted out via a simple BATCH file and a simple FTP script. Note that the script will have the username and password in it. Don't save it somewhere accessible by unauthorized users.Create the SCRIPT File
1. Start "Notepad"
2. Paste the following lines into your new document:
lcd [local download directory]
4. Start "Notepad" again
5. Paste the following lines into your new document:
You might want to add the decompression of the downloaded feed file. Adding this to the BATCH file after the FTP is a good place for that.
If there is already an older feed file, Gzip would stop and ask if you would like to overwrite it. That is of course not so good if you automate it. You can add a line that deletes the extracted feed file, if it exists.
The BATCH file would look like this:
gzip -d filename.txt.gz
6. Save the BATCH File as [name].bat such as "linkshare_merchant_999.bat" in the same directory where you saved the SCRIPT file already.
7. Double-click the BATCH file in Windows Explorer to start it. Done.
The BATCH file can be scheduled to run every day or so. A "task" could be created under Windows to do that. This is something your IT department can help you with, as well. (Type "task" in the "run" textbox and enter to open the Windows task scheduler application if you want to do it yourself.)
The script you need to create is a shell script and pretty much like DOS batch files. The script automates downloads from the Linkshare FTP server.
It uses the program "wget" which is pretty much standard on every Linux install. You could use "ftp" just like you do in Windows, but for automation, wget is your best choice.
At the end of the script it uncompresses the files for you. I included a wget entry for each feed I want to download. Before you can run the script you can make sure your script is executable by doing:
[admin@plain admin] chmod +x download_script
chmod means "change mode", +x means add an executable flag to the file.
now to download all your feeds you can type this:
[admin@plain admin] ./download_script
/usr/bin/wget -nv --dot-style=mega ftp://username:firstname.lastname@example.org/merchant_id1_mp.txt.gz
/usr/bin/wget -nv --dot-style=mega ftp://username:email@example.com/merchant_id2_mp.txt.gz
/usr/bin/wget -nv --dot-style=mega ftp://username:firstname.lastname@example.org/merchant_id3_mp.txt.gz
gzip -d *txt.gz
delete from tbl_merchant;
load data infile '/path/to/linkshare/feed/merchant_id_mp.txt' into table tbl_merchant fields terminated by '|'
lines terminated by '\n';
optimize table tbl_merchant;
select count(*) from tbl_merchant;
Other Data Feed Guides, Articles and Resources for Affiliates and Advertisers|
See the Advertiser Kit to learn more about sponsorship opportunities at Cumbrowski.com. Press? Download my Media Kit.