Overview
The client needed a streamlined way to manage and display a large number of products on their WordPress website using Google Sheets as a data source. Rather than manually uploading product details and images, the solution had to automatically import product data from Google Sheets and display images from external URLs, eliminating the need for image uploads to WordPress.
I developed a custom WordPress plugin that uses the Google Sheets API to import products and display images directly from external sources.
Challenges
- API Integration: Implementing the Google Sheets API to fetch data in real-time while maintaining security and data integrity.
- External Image Loading: Ensuring WordPress would display product images from external URLs without affecting site performance.
- Product Syncing: Automating the synchronization of product data (including name, price, and description) without manual intervention.
- Performance Optimization: Handling large product catalogs efficiently, minimizing page load time and server load.
Objectives
- Develop a custom WordPress plugin to fetch product data from Google Sheets.
- Automatically sync product information with the WordPress database.
- Display product images from external URLs without uploading them to WordPress, reducing server storage usage.
- Ensure the solution was user-friendly for site admins to manage and update products.
Solutions
1. Google Sheets API Integration
- Used the Google Sheets API to connect WordPress with the Google Sheets document.
- Implemented OAuth authentication for secure access to the Google Sheets.
- Mapped the product data columns in the spreadsheet (product name, description, price, image URL, etc.) to the corresponding product fields in WordPress.
2. External Image Display
- Configured WordPress to use external image URLs for product images, bypassing the need to upload images to the WordPress media library.
- Modified the product display template to ensure images load from the external URLs, avoiding storage bloat and making it easier to manage image updates directly in Google Sheets.
3. Automation & Syncing
- Added an admin panel within WordPress to allow manual syncing of products or scheduled automatic syncs using WordPress cron jobs.
- Every sync would update product data based on the latest information from Google Sheets, ensuring the WordPress site was always up to date with minimal manual input.
Technologies Used
- Custom WordPress Plugin Development
- Google Sheets API
- Google API Authentication
- PHP & JavaScript
- WordPress Cron for Scheduled Syncing
- External URL Handling in WordPress
Ongoing Maintenance
- The plugin was deployed on a scalable hosting platform, ensuring it could handle varying loads and provide a smooth user experience.
- We provided ongoing support and maintenance to ensure the plugin remained up-to-date with the latest WordPress WooCommerce updates and improvements.
Results
- Efficiency: The client could now manage their product catalog directly from Google Sheets, which simplified the process of updating products.
- Cost-Effective: By displaying images from external URLs, the client saved significant server storage and bandwidth, improving overall site performance.
- Time-Saving: Automated syncing eliminated manual entry of product data, saving time for the site administrator.
- Scalability: The plugin was designed to handle large product inventories without impacting site speed or performance.
Project Overview
Project Name:
Custom WordPress Plugin to Import Products from Google SheetsIndustry:
EcommerceClient:
Juan
What Our Customer Say About Us
Phil Castro
Founder @ Kamp“Abid goes above and beyond for his clients. Initially I reached out with a problem I had and he not only responded promptly, but also didn’t stop until the issues were 100% resolved. His work ethic is unmatched and his skill sets for almost anything web related is impeccable. If you have a problem, he has a solution.”
Daniel Kort
Author & Coach“Abid manages my website and I am deeply satisfied with his level of skill and integrity. In our first month of working together, he went above and beyond to make sure my website was safe and functioning optimally. I can’t thank him enough for his close attention to detail and the thorough job he does. I’ve had so many opposite experiences with other tech professionals that I feel like I’ve come across a true gem in finding Abid. He is fair, patient, and gifted at what he does, and so I highly recommend Abid and his website development and maintenance services”
Mika Jones
Very good delivery. Highly recommended as long as it does not clash with our work for him! Because we shall be re engaging with his services. He thinks outside the box and went the extra mile. Needless to say and repeat again. WE RECOMMEND HIS SERVICES. Reach out for more info. Happy to recommend
Dasa
Founder @ Let's Face ItI have hired Abid a few times and every time he performed excellent job. He has great skills and tries to resolve every task at his best abilities. I would re-hire Abid again in the future.
Sasha
Founder @ Nationwide ConsultingAbid was excellent throughout and had to be especially patient as I know next to nothing about what we trying to accomplish with the API integration! Highly recommend him.
lizelfving
CEO @ Pro SystemsI am absolutely impressed by the attention to detail Abid gave to my work. I contacted with many developers the I found his gig. I can honestly say that I have finally found a professional developer here on fiverr that I can work with to resolve any issues that may arise in web development. No other developer went into as much detail as Abid did. He is very knowledgeable, expert in his field and was able to find a solution for every problem. I feel at ease after this work. Moreover, he is very patient as well he , he never said No for any task we assigned. Hope to work again and again.
Mika Jones
Very good delivery. Highly recommended as long as it does not clash with our work for him! Because we shall be re engaging with his services. He thinks outside the box and went the extra mile. Needless to say and repeat again. WE RECOMMEND HIS SERVICES. Reach out for more info. Happy to recommend
Saad Buttar
Founder @ Buttar & Associates"Neural Sol's team did an excellent job creating our website. Abid and his team are highly skilled and provided innovative ideas that enhanced our project significantly."
Nuraden
I very much enjoyed getting help with my website development. I felt confident in my website with the results that was given to me. Abidanchan is a greater website developer and advisor when it comes to creating successful e-commerce website.
Saurab Hissar
great guy.... understood our need and gave us a great result his knowledge of Coding and his grip on visualisation of data is great.... best of all he is willing to edit and make changes without any problem..... Good Job keep it up
Umair Amil
His work was outstanding, as expected. I'm looking forward to working with him again
Amar
Abid has delivered on every promise and commitment and provided expert advice and very creative solutions to our challenges. Abid listened to our needs and requirements and devised a plan to move us forward quickly and within our budget. Thanks Abid