I have 2 websites:
[login to view URL]
[login to view URL]
These stores dropship products from a variety of suppliers. The suppliers are
[login to view URL]
[login to view URL]
[login to view URL]
And more will be added after this project.
Thus far we have had this script scrape the products from the supplier websites (jbmetro/sweetcraft), and upload them to the shopify stores automatically. All snacks were uploaded to snackland, and all products were uploaded to grocery.
The current scraper I'm using is available here. Most of the functionality is available but I want to expand on it and ensure it is working, hence the need for an update. You can use this code as a base and expand on it.
[login to view URL]
The aim of the scraper is to keep accurate pricing (prices may change due to sales/inflation) and to keep accurate product history. I want the inventory/pricing updated everyday at 7am, 11pm, and 4pm, in the GMT+10 Time Zone. Products may also be added, or deleted from the suppliers website. These changes will need to be reflected on our end. So if a product is added to jb metro it is added to our store at the next update, and if a product that is removed from jb metro, it is taken off the store.
A lot of the suppliers sell cases of products (12/24 packs). The example product on the side by jb metro is a protein bar that comes in a box of 16. This is because it has (x16) in the title. The price is also for a 16 pack. For my stores, I want to sell the 16 pack, but I also want to sell an individual bar.
So for this product, when it is uploaded to my store, it should have the option to buy 1 bar or 16, which can be done by using a variant. The price should also reflect it, but i will talk more about that later.
Here is an example of a product with a variant.
[login to view URL]
Product Title step by step:
Product titles must have the case amount removed. This will be put as a variant.
Example before: 34G LIFESAVER FRUIT TINGLES (x36)
Example after: 34G LIFESAVER FRUIT TINGLES
Product titles must have the weight (often in grams/kilograms) at the end of the title.
Example before: 34G LIFESAVER FRUIT TINGLES
Example after: LIFESAVER FRUIT TINGLES 34G
They should be changed from all in capital letters or lower case letters to having the first letter of each world capitalized.
Example before: LIFESAVER FRUIT TINGLES 34G
Example after: Lifesaver Fruit Tingles 34G
Now the PRODUCT TITLE is complete
Product description:
Product description should have the product name in it and use chatgpt.
They must be at least 50 characters.
The prompt you want to give it is:
Please write an SEO rich product description for **insert product name** in 50-100 characters.
Product Image.
All products need images.
Images are generally fine, regardless of whether it shows one product or the full case.
The only issue is watermarks. All jb metro product images have watermarks, and some bonefect and sweetcraft have watermarks. Watermarks is any product image that has ANYTHING on top of it.
Jb metro has a faint overlay
Bonefect often has box of ___ on top of it.
Solution: the solution in the code is to use an api with a watermark remover. You can use whatever solution like searching google for an alternative similar image or taking the first listings image when you look up the product name on google.
Vendor field: The vendor field in shopify is the Brand name. You can use the method in the current code or use chatgpt api.
Tags by collections: The product should be tagged with all categories it came from. E.g. if you take 1KG AURORA ESPRESSO 100% ARABICA BEANS (x1) From JbMetro, it comes from GROCERIES - COFFEE - and then BEANS. All of these should be tagged as individual tags. So the product will have one tag called groceries, one called coffee and one called beans. This applies for all websites.
Upc/barcode: All products need a barcode, that is specific to that product/variant. On JBmetro it provides an inner and outer barcode where available. The inner barcode is the individual product and outer is the case. For products without barcodes, the script currently gets the top search from google by searching the product name + barcode and takes the first number result. You can look at the script for more detail. Still however some products are missing there value
SKU: Should be a 6-9 digit number which is NOT shared with any other variant/product.
Variants: As what i said on page 1, most products should have an option to buy 1 or the full case. The case variant should show the case amount as the name which depends on the product. If the product is just 1 being sold individually, the the price needs to be divided by the case value, 0.50 is added and then multiplied by 1.3.
For case products they are just sold for 50c more and then multiplied by 1.3
The listing for 85G EQ LEAN PROTEIN COOKIE COOKIES N' CREME (x12) with the price of $33.49 will have 2 options, one for one cookie and one for the box of 12.
The individual cookie variant will have its own barcode, and sku. The price is 33.49, so we divide that by the box amount for the per product cost price of an individual cookie. 33.49/12 = 2.79.
We then add 0.50
2.79+0.50 = $3.29
Then we multiply by 1.3.
3.29*1.3 = 4.27.
That is the selling price for an individual cookie.
For the case variant, it is just 50c added,
33.49+0.5= 33.99
And then multiplied by 1.3
33.99*1.3 = 44.187
Sales channel - You need to include all sales channels in the options.
Product locations - Each supplier has there own location on shopify. Stock in shopify should show up in its designated stock location
Troubleshooting - overriding ability
While this is all good, the supplier's system we get products from have errors themselves and nuances we have to fix. For example, bonefect sells [login to view URL] which doesnt mention the case value in the title.
[login to view URL] has the case value, but we cant sell indivudal sour straps,
Therefore, we need a way to override the product titles, price, image ect. In other words, we need a way to make sure a product does NOT update for specific products. Im not sure how this can be done… Maybe a dashboard that when a product gets updated there, it updates both snackland and grocery go?
Hi, I am Senior Python script developer with 10 years of experience. I can scrape your required websites by python script/bot with your instructions very short time. Can we discuss please? Thanks
hey there,
Already i check your attached all website, I can provide you scrape the products from the supplier websites .And i can start the work right now and delivery the work within 48 hours.
Hello,
Having successfully completed projects similar in nature to yours, I am confident I will be able to deliver high-quality results. My skills in data scraping and data processing, particularly using Excel and Python, align perfectly with your project requirements, making me an ideal candidate for this job. I've worked extensively with web scraping and data collection tasks using APIs and bot automation, which is exactly what you need. Moreover, my proficiency in programming languages like PHP and HTML will allow me to update and expand upon your existing codebase while maintaining accuracy and functionality.
Accurate pricing and product history are vital for any online retailer, especially when products come from a variety of suppliers. My attention to detail combined with my ability to work with large datasets ensures that not a single price change or product addition goes unnoticed. I can even have the system updated thrice daily at 7am, 11pm, and 4pm GMT+10 Time Zone as per your requirement.
Lastly, as a seasoned writer and editor, I bring valuable creative skills into the mix. I'll not just scrape the product data but also ensure that these listings meet quality standards across all dimensions – product titles will be correctly formatted, descriptions will be SEO optimized, relevant tags will be allocated down to the collections from where the products came from. Let's make your store more appealing together! I'm ready to
Thanks!
Hello,
I understand that you need a comprehensive scraper to automate the process of updating product data from various suppliers to your Shopify stores, Grocery Go and Snackland. Your existing script has some functionality, but you want to enhance it to ensure accurate pricing and product history updates. This involves scheduling updates at specific times and handling variations for product cases and singles, as well as managing product titles, descriptions, images, and barcodes.
I will start by reviewing your current script and then implement the changes needed to reflect the suppliers' updates accurately. Each product will need to have the correct title format, description, and images without watermarks. Additionally, I will create a system to allow for manual overrides for products that have discrepancies to ensure that everything runs smoothly.
Could you clarify how you would like to handle the manual overrides for products that require specific changes?
Thanks,
Muhammad Awais
Hello,
I am excited to automate the scraping of products from a supplier's website to your Shopify store. I have attached an example of a very similar project I completed a while back. The project involved scraping products from a supplier's website, modifying them, and then uploading them to a Shopify store using the Shopify API. I would like to implement the same process for your project.
With my experience in Python, Data Processing, Excel, Web Scraping and Data Mining, I can help you reach your project goals efficiently.
My priority is to deliver perfect results and take the technical burden off your shoulders so that you can focus on the core aspects of your business.
Here is a similar project I completed:
https://www.freelancer.com/u/kbarbarius?review_context_id=38455205&review_type=project&sb=t
Please message me to discuss how I can assist in making this project a success.
Looking forward to working together.
Regards
KBarbarius
Hi Toby J.,
I’m Jovan, and I’m excited about the opportunity to work on your project titled product data scraoed I have thoroughly reviewed your project description and understand that you are looking for [specific requirements or goals mentioned in the job post].
Why I’m a Great Fit
With over 9 of experience in Data Cleansing and Data Scraping], I have successfully completed similar projects, including [briefly mention relevant past projects or experiences]. My skills in Data Cleansing and Data Scraping allow me to deliver high-quality results that meet your expectations.
Understanding Your Needs: I will ensure a clear understanding of your objectives to tailor my approach effectively.
Deliverables: You can expect [outline what you will deliver, e.g., reports, designs, code] by your deadline.
I believe in maintaining open lines of communication throughout the project to ensure alignment and address any concerns promptly.
I would love the chance to discuss this project in more detail. Please feel free to reach out so we can explore how I can help you achieve your goals.
Looking forward to hearing from you!
Best regards,
Hello, Dear Employer,
My name is Maiwand W from the United States.
As an Experienced Software Developer, I couldn’t resist applying to your job posting, and I would like to learn more about your project and share my approach. Do you have time for a quick-chat or meeting?
➤What will I do for the success?:
I will start by updating the current scraper script to ensure accurate pricing and product history maintenance. I will work on expanding the functionality to meet the specific requirements of updating inventory/pricing at scheduled times in the GMT+10 Time Zone and reflecting any changes from suppliers on your end.
➤ My previous experiences:
In my previous projects, I have successfully developed and maintained automated scraping tools and integrated APIs for data processing and transformation. I have a proven track record of delivering high-quality solutions in similar projects.
➤ My relevant skills:
- Proficiency in web scraping and data automation
- Strong experience in API integration
- Expertise in Shopify development and customization
- Familiarity with product data management and variant handling
➤ Comments:
To ensure the successful development of this project, I recommend setting up a robust error handling mechanism to address any issues with supplier data inconsistencies. Additionally, implementing a user-friendly dashboard for product overrides can enhance the flexibility and control over the product management process.
Kindly initiate the chat or meeting so we can discuss each aspect of this project thoroughly.
I want to work with you and hope to keep a long-term relationship with you.
With gratitude,
- M.W -
Hi,
I'm a Data Scientist with over three years of experience specializing in data analysis, Web-Scraping, and machine learning.
I have good experience scraping data with python using Bs4, Scrapy and selenium.
I think I can do this project if you are interested.
I propose to enhance your existing product scraper for GroceryGo and SnackLand, ensuring that it efficiently handles product updates from suppliers like JB Metro, Sweetcraft, and Bonfect. The updated script will ensure accurate and timely updates of product prices, availability, and history, with automatic syncing three times a day at 7 AM, 11 PM, and 4 PM (GMT+10). Additionally, I will implement variant management for bulk products (e.g., 16-pack protein bars) to allow customers to purchase individual items or bulk packs with correct pricing. This solution will provide seamless integration with Shopify, ensuring your inventory is always current and reflecting supplier changes. My goal is to maintain an automated and scalable solution for adding new suppliers and managing your product data effectively.
Hi i checked your requirement understood the task i have done plenty of webscraping tasks i would recommend you to have chat
time required:4-5 days
my skills:bs4,selenium,playwright
Hi there!
As I have read, I see you need help expanding and updating your product scraper to ensure accurate pricing, inventory management, and product history updates for your Shopify stores, and I could help you!
I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front.
I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools.
Send me a message so I can show you my previous work and we can discuss more.
Best Regards,
Giovanni.
I understand the complexity of your project and have extensive experience in data scraping and web automation to tackle even the most challenging tasks. Your project requires handling large amounts of data, collecting and organizing information from multiple sources, and ensuring accurate pricing and product history - all of which are areas I specialize in.
With my skill set, I can utilize the existing codebase as a base for expansion and customization, ensuring that our scraper performs with utmost precision while keeping up with varying market values and inventory changes. Importantly, I am well-aware of the gravity your business places on timeliness; for your EM7-11pm-GMT+10 daily store updates, I can offer a robust system that guarantees promptness without ever compromising accuracy.
Moreover, my experience in product listing, tagging, and content management would be valuable for streamlining your backend processes by effectively manipulating names, descriptions, and images from suppliers to match your specific requirements. I assure you that by choosing me on this project, you're not just hiring a skilled freelancer but someone who is committed to going above and beyond to deliver high-quality work on time.
So let's get started! Reach out to me now and we'll discuss how my solutions can bring efficiency, accuracy, and growth to your business.
With over five years of experience in web development and specializing in data scraping, my team at BN-Droids Digital Services is perfectly suited to handle your project. We have an impressive track record of extracting and managing large amounts of data daily, and we maintain a comprehensive database for over 7 million retail data points. This means that with us, you can be assured of meticulous attention to detail and reliable data accuracy.
Moreover, we have ample experience working with APIs which will be necessary for your project. We are adept at overcoming diverse web challenges, including dealing with watermarked images - a problem you've highlighted. From my understanding, I'd recommend using alternative images through a Google search or selecting the first listing on Google when searching for the product name.
Lastly, we highly value client satisfaction and I personally ensure timely communication and prompt completion of tasks. This project appears very structured - which I love! And we thrive on that structure because it allows us to utilize our organizational skills better.
No Results, No Payment – Your Success is Guaranteed!
Hi,
I specialize in Shopify API integration, web scraping, and automation. I can update and enhance your existing scraper to meet all your requirements.
Key Features:
Automate product updates (price, inventory, additions, removals) from suppliers.
Create individual and case purchase options with automated pricing calculations.
Format product titles (case value removal, weight adjustment, capitalization) and generate SEO-rich descriptions.
Remove watermarks via API or alternate solutions for clean product images.
Manage barcodes/SKUs and ensure unique, non-conflicting values for all variants.
Develop a dashboard for manual overrides (title, price, image, etc.) with Shopify sync.
Schedule automatic updates 3 times daily (7 AM, 11 PM, 4 PM GMT+10).
Why Me?
Proven expertise in Shopify integrations and Python-based automation.
Ability to tackle supplier data issues and ensure accurate synchronization.
Timeline: 10-15 days
Budget: $500 - $600
Let’s discuss your project to ensure all needs are met. Looking forward to collaborating!
Best regards,
Muhammad Numan