Create Google Docs Spreadsheet to help Analyze our Prices vs Competition
$30-250 USD
Cancelado
Publicado hace casi 9 años
$30-250 USD
Pagado a la entrega
We have product feeds for our two websites that contains Manufacturer SKU/UPC, quantity in stock, price, sale price, etc. We want a Spreadsheet created in Google Docs that can import this info and then import our competitors' prices from a big price aggregation site, called SlickGuns.com. Along with this import, the database/spreadsheet should be updated automatically every few hours to have a psuedo-realtime pricing comparison.
So, for example, if you visit this link: [login to view URL]
You’ll see that there are a dozen or so dealers that have this product in stock, ranging from $614.11 to $696.77. The info we would want from this site would be:
-Our ranking, out of Total In Stock (8/14, for example)
-Lowest & Highest Prices
We’d also probably need the ability to exclude “x” number of entries, some SKU numbers are used for both firearms and accessories, causing the pricing table listed for these search results to be wonky (see example here: [login to view URL] where the cheapest four listings aren’t actually for the firearm).
Here’s an example of our own Product feed (links provided on request, if necessary):
<product>
<sku>27593</sku>
<name>
Mossberg.300 Win Mag Bolt Action Rifle- Walnut Stock, Fluted Barrel, and Scope Package Mossberg 27593
</name>
<permalink>
[login to view URL]
</permalink>
<price>469.00</price>
<sale_price>429.00</sale_price>
<image>
[login to view URL]
</image>
<quantity>0</quantity>
<attribute_firearm-type>Bolt-Action Rifle</attribute_firearm-type>
</product>
Important info needed from our XML would be SKU, Price, Sale Price (if any), and quantity. Obviously if the item is out of stock on our site, no price comparison is necessary.
I think this is almost all possible using the ImportXML and ImportHTML functions in Google Spreadsheets, but if there’s an easier way to do it, I’m open to other suggestions!
Hello Dear,
Sir/Madam,
HERE Ready to start Now!!!
I can perfectly do it and interested for this project. Have an experience same and different types of projects. I am waiting to your quick positive reply.
Feel free ask me question if any.
Have a nice day and stay fine:-)
Thanks
Hello I am sajidmahmud I see your project and i do it as your acceptation.
I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,SEO,Internet Marketing,Social Media,Lead,Telemarketing and Photoshop work would like to assure you that I will do my job according your expectation. I have a highly creative data entry studio. Just give me your jobs and find out me. Close communication & ON-TIME delivery ensures a long-term relationship with our valued clients. We believe, goodwill in business is worthier than anything else. I give you drafts and unlimited revisions until your satisfaction. I do through research on every project to get the Best result as well as optimum client satisfaction. I can do your job in a best rate.
Thanks
Hello Sir/Madam,i am ready to start your job as per your requirement Thanks this great opportunity,if you like than we can discuss further, awaiting for your positive response.I have been working in the field of Data-Entry,Excel,Web Search,Web scraping,Leads,Data Processing etc job from the last 4 years. I am good fit for your projects as i always be sincere with my clients and with my work. I aim to bring a modern but experienced approach to your projects. Allow me to provide you good services based on my experience and bring you vision to life looking forward to hear from you.
Thanks
Hello,
I'm excited to work on this for you. Please consider me for this project. I am diligent and detail orientated, driven by deadlines
Regards,
Juan