From Scraping EC Site to Updating Shopify: The Magic of Programming

Hello there!

Today, let's delve into the enchanting world of a program that performs what seems like magic—scraping information from an EC site, processing it, and updating product information on Shopify.

The Art of Scraping and CSV Processing

Extracting Information from the EC Site:

• Leveraging VBA and Selenium, it scrapes all product information from the EC site, acquiring rich data such as product names, prices, and details.

Generating Shopify-Ready CSV Files:

• It processes the obtained information and transform it into a CSV file formatted to Shopify's specifications.
  This file is ready for seamless upload.

Uploading to Shopify

Logging into Shopify:

• To upload the generated CSV file, we log into Shopify and navigate to the dashboard to control the upload process.

CSV File Upload:

• It uploads the CSV file from the dashboard, resulting in a bulk update of product information on Shopify.

Automated Deletion Process:

• For products removed from the original EC site, the program autonomously searches on Shopify and carries out the deletion process.

Automated Scheduled Execution and Business Transformation

Scheduled Program Execution:

• Using VBS files and the Task Scheduler, the program runs automatically at scheduled times, ensuring that product information on Shopify stays up-to-date.

Complete Automation of Operations:

• The program fully automates the daily task of updating product information that the client used to spend hours on, significantly reducing time and effort.

Diverse Program Implementations

Website Scraping:

• Information is extracted from the content-rich EC site.
  Scraping is a technique for extracting data from web pages, eliminating manual efforts.

CSV Processing:

• The obtained information is automatically formatted for Shopify.

Browser-Controlled Uploads:

• The program efficiently manages the upload process to Shopify.

Search and Delete Operations:

• Automated processes for searching and deleting products that have been removed.

Scheduled Program Execution:

• The Task Scheduler ensures the program runs daily at scheduled times.

Cost and Benefits Comparison

The development of this extensive program costs approximately between 70,000 to 90,000 yen (approx $460 - 600).
However, with a monthly efficiency gain of over 30 hours, the cost-effectiveness is substantial.

Through this new system, you'll experience how your operations can become much more efficient.
If you have any questions, feel free to reach out.

If you are interested in using scraping to retrieve large amounts of information from websites or automate computer tasks to increase work productivity, please contact Uesugi.