Easy Products Auto Import

Importing products from Google Sheet can significantly streamline your inventory management and simplify bulk updates. This guide will walk you through the steps to set up and execute a product import from a Google Sheet to your store.

This allows you to manage products efficiently. Once installed, you only need to update your Google Sheet or the website to add or update products, regardless of when the changes are made. You can also manually set up a Cron job for automatic updates.

Features:

• Update Product Data in Google Sheets & Sync with Website.
• The admin can schedule a Cron job to add or update products through the system configuration settings.
• The admin can enable or disable the module via the system configuration settings.
• The admin can integrate Google Sheets using the system configuration settings.
• The admin can specify which products to add or update in Google Sheets through the system configuration settings.

 Google Sheets API Setup:

1. Create a Google Cloud Project:

• Go to the Google Cloud Console.
• Create a new project.
• Enable the Google Sheets API for your project.

2. Create OAuth Credentials:

• Under the “APIs & Services” section, go to Credentials.
• Create a new OAuth  Client ID or Service Account.
• Download the credentials (JSON file).

3. Share the Google Sheet:

• Share the sheet with the email in your service account credentials.