Hmm... I need to find out myself. I don't know what is the right answer. I'll do some investigation and get back to you if I got an useful answer. You should email the people at iPage as they probably can answer it..
Is there any way that I can make a PHP program that can read the .txt file, and based on the location of the text in the file can read a certain portion. The format of the .txt is tab delimited if that helps. I put the first three columns of text below. (the portion I am sure contains the product quantity).
When I put the text from that file into here it gets scrunched together to make it less readable. I put more spaces in between this time so it is more readable, and I only put one line in this time..
Thanks in advance for any future help, and I will contact the company for more info...
I found out what each column is for:.
Column1: SKU Sorted by item number (SKU).
Column2: available (current, unadjusted, available quantity) This is what is available for you to sell.
Column3: openpo (quantity on order) This is what we have on order with our supplier.
Column4: exprecdate (earliest expected receipt date for orders) This is only a best guess when we’ll be receiving these items.
Column5: status (D- Discontinued; O- Special Orders; P- Pre-Sell; S- Stock) This tells you if an item is something we stock, has been discontinued, can be pre-ordered, or it is a special order..
Column6: cost (dealer cost) This is the cost you will pay us, exclusive of any fees.
Column7: msrp (retail price) This is the price suggested by the manufacturer that you sell at.
Example tab delimited row in .txt file:.
This post has been edited by.
: 25 August 2004, 13:57..
You can do this via easy populate. put the info from your txt into an easypopulate txt and then upload..
With a vb script, you can do it easily...
Ok, I can get Easy Populate, but I wouldn't know how to make a VBscript to do this. Another thing - I receive a knew text file every day; will have to manually put this text into easy populate every time I get a new file or can I make it automatic somehow? For example a run at a certain time script...
Once you get figured out how to 'merge' the data into a format easypopulate works with, then all you have to do is turn on the macro recorder, and then 'merge' the data, step by step and once done, turn off the macro recorder..
Then run the macro to see how it does. you may have to tweak things..
I am assuming you have excel or openoffice spreadsheets, or even lotus..
I'm working on getting this Easy Populate contribution. I will try to follow your instructions as best I can. Thank you for all your help. I love this forum! I'm leaving for work now so I won't get this done for a little while. Thank You!..
I installed easy populate. I am now trying to figure out how to get the format right. Mibble- earler you mentioned that it could be done with a script. I'm looking for alittle more automation than I can do with excel...
I would like to modify oscommerse (with a contribution or without) so that it can read the .txt file whenever the .txt gets replaced with a new one. My supplier sends me inventory updates as often as every hour! I would like to use easy populate if I can, but I can't figure out how to use it for my purposes. (update just the product quantity in the fashion that I described earlier)..
I sell products with the dropship method. The company that dropships for me has a system that automatically updates my stock levels to their current inventory via FTP. They send me a .txt file with the product quantities in it. What I need to know is how to take this information from the .txt file and make it work with OsCommerse.(show product quantity just like it normally does, but get the quantity FROM the .txt file) Here is a small portion of the .txt file:.
I know for sure the first set of numbers in quotes are the product numbers..
I don't know for sure which numbers are the quantity numbers. I'll figure that out later. For right now lets pretend that the 2nd set of numbers is the quantity..
Any help would be appreciated! Please keep in mind that I do not know PHP, but I am good at following directions and I learn fast...
1. Request the company that sends you the text file to supply with you with a record structure for the textfile, describing the name of each field, the delimeter if any between fields, the field data tpye,etc,etc..
2. Have a look at the "Easy Populate" contribution, as it uploads a (flat) file into the database, therefore, you may well be able to easily clone a PHP script from the EP contribution, assuming that is within the contribution licence guidlines..