Page 1 of 2 12 LastLast
Results 1 to 25 of 43
  1. #1
    Affiliate Marketing Consultant Andy Rodriguez's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Miami
    Posts
    8,384
    ReStockIt.com - SAS Data Feed - Updated
    Hello team,

    The RSI massive data feed has been loaded tonight into SAS. There are now 68,626 items ready for your targeted traffic when you log into your RSI SAS account. Look for monthly automated updates going forward.

    The CJ feed will stop being updated in Q1, if you haven't changed your links to the SAS program, please do so in Q1.

    The size of this feed has been a challenge and I wanted to thank Brian and crew for working on this with us.

    Lock and load folks, thank you for your patience...
    Andy Rodriguez Consulting, Affiliate Program Management and Consulting Services, Since 2001
    www.andyrodriguez.com | E: abw@andyrodriguez.com | P: (888) 931-ANDY (2639) | Skype: affiliatedoctor | AIM & MSN: AffiliateDoctor | Subscribe To Our ABW Forum Posts | Follow me on Twitter | Join Our Affiliate Programs

  2. #2
    notary sojac Herb ԿԬ's Avatar
    Join Date
    January 18th, 2005
    Location
    Central/Western NY State
    Posts
    7,741
    and at GoldenCAN?

  3. #3
    Affiliate Marketing Consultant Andy Rodriguez's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Miami
    Posts
    8,384
    Quote Originally Posted by Herb ԿԬ
    and at GoldenCAN?
    already sent to the Golden man for updating ...
    Andy Rodriguez Consulting, Affiliate Program Management and Consulting Services, Since 2001
    www.andyrodriguez.com | E: abw@andyrodriguez.com | P: (888) 931-ANDY (2639) | Skype: affiliatedoctor | AIM & MSN: AffiliateDoctor | Subscribe To Our ABW Forum Posts | Follow me on Twitter | Join Our Affiliate Programs

  4. #4
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    I'm kind of disappointed in the category structure.
    example:
    OfficeJanitorial/Maintenance & Lunchroom SuppliesCleaning SuppliesGlass

    How on Earth can anyone use THAT? I can handle the filesize (having to split it into 3 seperate files once I download it to do my tweaking, but I'm at a loss of tricks to use that category structure.
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  5. #5
    ABW Veteran Mr. Sal's Avatar
    Join Date
    January 18th, 2005
    Posts
    6,795
    Quote Originally Posted by Nature Boy
    I'm kind of disappointed in the category structure.
    example:
    OfficeJanitorial/Maintenance & Lunchroom SuppliesCleaning SuppliesGlass

    How on Earth can anyone use THAT? I can handle the filesize (having to split it into 3 seperate files once I download it to do my tweaking, but I'm at a loss of tricks to use that category structure.
    Scott, you're not alone on this one.

    Not only that the categories are too long, but I also don't like this:
    <b>HANDLING FEE:</b> ......
    <b>HANDLING FEE:</b> ......
    <b>HANDLING FEE:</b> ......
    <b>SHIPPING INFO:</b> .....
    <b>SHIPPING INFO:</b> .....
    <b>SHIPPING INFO:</b> .....
    <b>DETAILS: </b> ......
    <b>DETAILS: </b> ......
    <b>DETAILS: </b> ......
    etc,etc,etc .... At the beginning of every product description and the ---- <br><img src = "/images/manufacturer/icon/WHATEVER.gif" .... At the end of many products description.

    If the feed was smaller, maybe it can be handled on the local HD, but with over 68K products, it must go directly from SAS to the server, and while it only takes less than three minutes to get the feed from SAS, and have a ready made site with over 68K products pages, there is no way to fix that many problems on the server, the way it's now, I would get over 1,540 long text category links.

    I guess that unless the RSI datafeed get formatted different, I am going to have to settle with GoldenCan, or the SAS make-a-page in order to have any RSI product pages done.


    Maybe the PHP gurus have no problem tweaking that monster, but while I am self learning new tricks with PHP everyday, I think it might take me another year to become a PHP Houdini.

  6. #6
    Full Member jollygoodpirate's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    227
    Cleaning Datafeeds
    So you would want the datafeed to be cleaned to your specifications. Would that be a service other webmasters may be interested in?

  7. #7
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Quote Originally Posted by jollygoodpirate
    So you would want the datafeed to be cleaned to your specifications. Would that be a service other webmasters may be interested in?
    I wouldn't say to our specifications, but at the very least, to the way the previous feeds we set up.

    In the old feed, the categories were set up like this:
    Janitorial & Cleaning\Cleaning Agents\Misc. Cleaners
    Now it's like this:
    Janitorial & CleaningCleaning AgentsMisc. Cleaners

    I could work with the \ in there.
    Quote Originally Posted by Mr. Sal
    etc,etc,etc .... At the beginning of every product description and the ---- <br><img src = "/images/manufacturer/icon/WHATEVER.gif" .... At the end of many products description.
    Agreed. The description field is a mess too.

    At least the SAS and CJ zip files on Andy's server have been updated, and I can use those as I have in the past, but it's a complete waste to have it via the SAS FTP and not be able to use it.
    http://www.andyrodriguez.com/merchan...i-sas-feed.zip
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  8. #8
    Full Member jollygoodpirate's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    227
    Quote Originally Posted by Nature Boy
    I wouldn't say to our specifications, but at the very least, to the way the previous feeds we set up.

    In the old feed, the categories were set up like this:
    Janitorial & Cleaning\Cleaning Agents\Misc. Cleaners
    Now it's like this:
    Janitorial & CleaningCleaning AgentsMisc. Cleaners
    Your are right, you can't explode the categories without a separator. I can't imagine that was done on purpose, it looks more like an oversight.

  9. #9
    Comfortably Numb John Powell's Avatar
    Join Date
    October 17th, 2005
    Location
    Bayou Country, LA
    Posts
    3,432
    I can handle the filesize (having to split it into 3 seperate files once I download it to do my tweaking, but I'm at a loss of tricks to use that category structure.
    Scott - Could you share how you split this big file?

  10. #10
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Exclamation
    Quote Originally Posted by bumpaw
    Scott - Could you share how you split this big file?
    I manually open the file up using Textpad.

    Here's the best way I've found so far to do this in Textpad:
    1. Open the txt file in Textpad.
    2. Highlight the first line.
    3. Click SEARCH (in the menu bar), then GO TO... and input line 20000 (or so) and check the box marked EXTEND SELECTION. This highlights the first 20000 (or so) lines.
    4. Perform a CUT.
    5. Open up Excel.
    6. Paste
    7. Save that file
    8. Repeat
    Doing this, reduces the file size to something a bit more manageble (on a machine with only 1GB of RAM) so that I can use my Excel macros to do my tweaking. It's not perfect, but it'll have to do... for now.
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  11. #11
    Comfortably Numb John Powell's Avatar
    Join Date
    October 17th, 2005
    Location
    Bayou Country, LA
    Posts
    3,432
    # Click SEARCH (in the menu bar), then GO TO... and input line 20000 (or so) and check the box marked EXTEND SELECTION. This highlights the first 20000 (or so) lines.
    # Perform a CUT.
    Do you reassemble it in Textpad prior to upload?

  12. #12
    Affiliate Marketing Consultant Andy Rodriguez's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Miami
    Posts
    8,384
    Hi Folks,

    For file splitting I have been using this app for years: http://www.gdgsoft.com/gsplit/index.aspx

    There is a new person inside RSI that has been assigned to affiliate program support and we met last week. Look for monthly scheduled updates on the feed, monthly/weekly coupons and better integration with the merchant.

    The feed categorization has been noted and will be fixed asap.

    Thanks,
    Andy Rodriguez Consulting, Affiliate Program Management and Consulting Services, Since 2001
    www.andyrodriguez.com | E: abw@andyrodriguez.com | P: (888) 931-ANDY (2639) | Skype: affiliatedoctor | AIM & MSN: AffiliateDoctor | Subscribe To Our ABW Forum Posts | Follow me on Twitter | Join Our Affiliate Programs

  13. #13
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Quote Originally Posted by bumpaw
    Do you reassemble it in Textpad prior to upload?
    I haven't gotten that far yet, been finishing up on Christmas marketing this past week, but, more than likely I will try to recombine the files before putting the data into Webmerge.
    Quote Originally Posted by Andy Rodriguez
    For file splitting I have been using this app for years: http://www.gdgsoft.com/gsplit/index.aspx
    I might give that a try, thank Andy.
    Quote Originally Posted by Andy Rodriguez
    The feed categorization has been noted and will be fixed asap.
    Very good
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  14. #14
    Comfortably Numb John Powell's Avatar
    Join Date
    October 17th, 2005
    Location
    Bayou Country, LA
    Posts
    3,432
    For file splitting I have been using this app for years: http://www.gdgsoft.com/gsplit/index.aspx
    I tried GSplit a while back and it appears that the components of a large file are not usable in Excel or Textpad. It looks great for file transfer, but unless I'm missing something you would have to reassemble the file to work with it. Once you reassemble you are back to the "to large for Excel" problem. I think Nature Boy solved my problem.

  15. #15
    Affiliate Marketing Consultant Andy Rodriguez's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Miami
    Posts
    8,384
    Quote Originally Posted by bumpaw
    I tried GSplit a while back and it appears that the components of a large file are not usable in Excel or Textpad. It looks great for file transfer, but unless I'm missing something you would have to reassemble the file to work with it. Once you reassemble you are back to the "to large for Excel" problem. I think Nature Boy solved my problem.
    J, that does basically what NB described but in an automated way. You can also script it and save the settings for later use. Once you cut or split the file into the size and parameters you want / need, you can load each "chunk" into excel or textpad ( I use TP as well, its a kick butt text editor) and work from there on...

    Would a SAS segmented file be helpful? We can try and work with Brian and segment the major cats into separate files if you feel its worth it.
    Andy Rodriguez Consulting, Affiliate Program Management and Consulting Services, Since 2001
    www.andyrodriguez.com | E: abw@andyrodriguez.com | P: (888) 931-ANDY (2639) | Skype: affiliatedoctor | AIM & MSN: AffiliateDoctor | Subscribe To Our ABW Forum Posts | Follow me on Twitter | Join Our Affiliate Programs

  16. #16
    ABW Veteran Mr. Sal's Avatar
    Join Date
    January 18th, 2005
    Posts
    6,795
    Would a SAS segmented file be helpful? We can try and work with Brian and segment the major cats into separate files if you feel its worth it.
    I think it would be a good idea. That way, maybe more affiliates will be able to just use the categories they need or want, and not have to deal with a big 70K products feed everytime there is a new full datafeed update.

    For example only:
    Party Supplies
    Kitchen Supplies
    Glassware Supplies
    Office Supplies
    Computer Supplies
    Janitorial Supplies
    Restaurant Supplies
    Restaurant Equipments
    Outdoor Storage sheds
    Storage Supplies
    Maybe some affiliates just want to work with only those 10 categories (could be any 10 or more different categories), but in order to get those 10 cat, they are forced to download the entire 70K product feed with over 1,500 different categories everytime they want to update, only the product pages of the categories they are using.

    Hell, maybe I don't know how to explain what I mean with that example, so here is my Capri way to explained:


    You have about 70 thousand products on the ReStockIt datafeed.
    The Shareasale default field names are:

    ProductID|Name|MerchantID|Merchant|Link|Thumbnail|BigImage|Price|RetailPrice|Category|
    SubCategory|Description|Custom1|Custom2|Custom3|Custom4|Custom5|LastUpdated|Stock
    The Shareasale default [Category and SubCategory], are useful when you're using a table with different merchants, and you want to select from the standard Shareasale default Category and SubCategory in order to display products of the same category from different merchants on your niche website or directory.

    What I have noticed is that if you just want to just promote only one merchant on that specific Shareasale default [Category and SubCategory], you can't just use the Shareasale default [Category and SubCategory], because most of the SAS merchants datafeed that I have dowloaded so far, have the same Name for Category and SubCategory under the Shareasale default [Category and SubCategory] field name for all of their products.

    But..........

    A few merchants have taken advantage of the Shareasale default [Custom1|Custom2|Custom3|Custom4|Custom5] fields for different categories, type, color, size, etc.

    And the ReStockIt datafeed only uses the Custom1 to name over 1,540 different categories, but the main problem I see with that, is that those 1,540 different categories, they all are four, five, or more category names long, on the same line, and under the Custom1 field name.

    So, I just have this idea:

    You can segment the major cats into separate files, or just use only one datafeed file, but segment the major cats under the [Custom1|Custom2|Custom3|Custom4|Custom5] default shareasale Field Names, instead of justs using the Custom1 only, the way it's now!

    -----------


    Btw...

    Originally Posted by Mr. Sal
    etc,etc,etc .... At the beginning of every product description and the ---- <br><img src = "/images/manufacturer/icon/WHATEVER.gif" .... At the end of many products description.


    I though that it might take me another year to learn how to get rid of all of that extra html junk from the products description, but I was wrong!

    I already learned how to get rid of all of that extra html junk from the products description in less than 24hrs.

    But now that I learned how to fix that, I still say that the feed sucks the way it's now. .

    =======================================================




    I don't want to make another post about this, so I would like to reply to jollygoodpirate on this same post.
    Quote Originally Posted by jollygoodpirate
    So you would want the datafeed to be cleaned to your specifications. Would that be a service other webmasters may be interested in?
    jollygoodpirate, read the colors reply.

    I don't want the datafeeds to be cleaned to my specifications, but if it's done to my specifications, I wouldn't complain.

    Yes, that could that be a service other webmasters may be interested in, in order to make some extra money, if other affiliates are too lazy to do it by themself, don't know how to do it, or just want to pay someone else to do the easy part.


    Btw jollygoodpirate, yesterday when I read your reply:

    I didn't knew if you was trying to be a wise guy, trying to insult me, or trying to come up with a money idea.

    Today, I no longer care if you were trying to be a wise guy, or were trying to insult me, but if you was thinking about a , all I know is that you just give me an idea to make some extra on the datafeed cleaning service.
    Last edited by Mr. Sal; December 18th, 2006 at 03:53 PM.

  17. #17
    Comfortably Numb John Powell's Avatar
    Join Date
    October 17th, 2005
    Location
    Bayou Country, LA
    Posts
    3,432
    GSplit- The documentation on their web site doesn't indicate it for the need we have. It took the big restockit.csv and split it nicely into 6 pieces. Each file was labeled with a .bsd extension. In the same directory it created a .exe file that will unite the 6 pieces. I tested and the pieces open with Excel and Notepad. The rub comes after you edit a piece file. The Unite.exe won't recognize the edited piece and it fails.

    My database was created to reject duplicate SKUs as that is the primary key. When it meets a duplicate it aborts the insert process. Well how can you get rid of the duplicates when some are in each of the six parts.

    I think in the end this feed will have to be created in parts conforming to the major categories like Office, Janitorial, Kitchen etc. It might be that I'm to thick for this baby and I just need to put my time on all the easier feeds that are around.

  18. #18
    Full Member jollygoodpirate's Avatar
    Join Date
    January 18th, 2005
    Location
    NC
    Posts
    227
    Not a wise guy; Not trying to Insult Anybody
    Quote Originally Posted by Mr. Sal
    Btw jollygoodpirate, yesterday when I read your reply:

    I didn't knew if you was trying to be a wise guy, trying to insult me, or trying to come up with a money idea.

    Today, I no longer care if you were trying to be a wise guy, or were trying to insult me, but if you was thinking about a , all I know is that you just give me an idea to make some extra on the datafeed cleaning service.
    Just to clarify, I was not trying to be a wise guy nor insult you.

    I can break up a feed easily, and I am trying to break into datafeed services, so I thought I'd ask if affiliates would actually pay for a service like that. I wouldn't do anything without talking with Andy, but that is exactly the type of service I could offer.

    So, please be assured I was not being a wise guy, and certainly I was not trying to insult you - just doing informal market research.

    If you go with the idea more power to you. I think affiliates could use it and they would like it, the question is would they pay for the service? Thus my original question.

  19. #19
    Comfortably Numb John Powell's Avatar
    Join Date
    October 17th, 2005
    Location
    Bayou Country, LA
    Posts
    3,432
    Scott:
    At least the SAS and CJ zip files on Andy's server have been updated, and I can use those as I have in the past,
    I used the link from here
    http://forum.abestweb.com/showthread.php?t=77494 to grab the feed for SAS. Here is the difference in the old product link and the new for OIC90078.
    Old:
    http://www.shareasale.com/r.cfm?m=10059&b=57580&u=!!USERID!!&urllink=www.restockit.com/2-Hole-Punch-2-34-Center-Holes-Punches-20-Sheets-Black-(OIC90078).html?c1=affiliate&source=sas&kw=datafeed
    New:
    http://www.restockit.com/2-Hole-Punch-2-34-Center-Holes-Punches-20-Sheets-Black-(OIC90078).html?c1=affiliate&source=sas&kw=OIC90078
    Gone is the !!USERID!! for my script to dynamically insert my affiliate number.

  20. #20
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Quote Originally Posted by bumpaw
    Gone is the !!USERID!! for my script to dynamically insert my affiliate number.
    Ick! That'll take a bit of rewriting to fix on my end

    Put me down for a yea for the SAS segmented file.
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  21. #21
    Affiliate Marketing Consultant Andy Rodriguez's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Miami
    Posts
    8,384
    Quote Originally Posted by bumpaw
    I used the link from here
    http://forum.abestweb.com/showthread.php?t=77494 to grab the feed for SAS. Here is the difference in the old product link and the new for OIC90078.
    Old:

    New:
    Gone is the !!USERID!! for my script to dynamically insert my affiliate number.
    That is the SAS URL redirect for RSI. I can append to the feed and reload or you can add to all the URL buy links, its the same link for all the feed. Here is the code to append to the front of the buy link / page url:

    Give me till tomm and I will reload to our server in the morning.
    Andy Rodriguez Consulting, Affiliate Program Management and Consulting Services, Since 2001
    www.andyrodriguez.com | E: abw@andyrodriguez.com | P: (888) 931-ANDY (2639) | Skype: affiliatedoctor | AIM & MSN: AffiliateDoctor | Subscribe To Our ABW Forum Posts | Follow me on Twitter | Join Our Affiliate Programs

  22. #22
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    2 months, no update, still one huge file...
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  23. #23
    ABW Ambassador Nature Boy's Avatar
    Join Date
    January 18th, 2005
    Location
    Tennessee
    Posts
    1,423
    Quote Originally Posted by Nature Boy
    2 months, no update, still one huge file...
    Anyone minding the store?
    Scott
    If you can't dazzle them with brilliance, then baffle them with bulls#!t
    Don't tell me that you'll do it... SHOW ME.
    Just because everyone else is drinking it is no reason for me to drink the KOOL-AID.

  24. #24
    Affiliate Marketing Consultant Andy Rodriguez's Avatar
    Join Date
    January 18th, 2005
    Location
    Sunny Miami
    Posts
    8,384
    Hi Scott,

    Not sure how we missed this post, here you go buddy.

    ReStockit.com Data Feeds:
    SAS Complete Data Feed
    SAS Segmented - Outdoor Sheds Data Feed
    SAS Segmented - Janitorial Data Feed
    SAS Segmented - Office Supply Data Feed
    SAS Segmented - Restaurant & Bar Feed
    CJ Complete Data Feed

    These are also loaded to our site under the merchant list here.
    Andy Rodriguez Consulting, Affiliate Program Management and Consulting Services, Since 2001
    www.andyrodriguez.com | E: abw@andyrodriguez.com | P: (888) 931-ANDY (2639) | Skype: affiliatedoctor | AIM & MSN: AffiliateDoctor | Subscribe To Our ABW Forum Posts | Follow me on Twitter | Join Our Affiliate Programs

  25. #25
    .
    Join Date
    January 18th, 2005
    Posts
    2,973
    Andy - is there some reason this update isn't posted at the SAS site? (Perhaps it's just "in the queue.") As others have noted, the last update on SAS appears to be mid-December.

    Since I'm implementing a system to automatically draw updated feeds from SAS, I definitely want to know if there is a reason to "work around" the SAS feeds and download some merchants' feeds from another source (such as from your site).

+ Reply to Thread
Page 1 of 2 12 LastLast

Similar Threads

  1. ReStockIt Data Feed - Updated - 6.05.06
    By Andy Rodriguez in forum Andy Rodriguez Consulting
    Replies: 42
    Last Post: July 12th, 2006, 01:51 AM
  2. Rugman - SAS Data Feed Updated - 5.11.06
    By Andy Rodriguez in forum Andy Rodriguez Consulting
    Replies: 0
    Last Post: May 11th, 2006, 04:58 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •