Skip to main content

Add Items - Data Feed

Use a spreadsheet or file to add and update your items automatically.

Available withSalesIncluded in the Complete plan.Plans and modules

Step 1: Go to https://www.facebook.com/commerce_manager/

Step 2: Choose your business and Select your previously created Catalogue.

Choose your business and Select your previously created Catalogue.

Step 3: Select the Items menu option and Click the Add Items button.

Select the Items menu option and Click the Add Items button.

Step 4: Choose your preferred option Data Feed for uploading products and Select the Next button.

Data Feed: Use a spreadsheet or file to add and update your items automatically.

Data Feed: Use a spreadsheet or file to add and update your items automatically.

(i) Use a URL or Google Sheets to upload products in bulk​

  • Choose the Use a URL or Google Sheets option.
  • Enter a URL from your server, hosting website or a Google spreadsheet. Click the Next button to proceed.
Enter a URL from your server, hosting website or a Google spreadsheet. Click the Next button to proceed.

Sample File URL: https://docs.google.com/spreadsheets/d/1Ozn8VKseOF8g0X-Of4OBYXu87xqA9X-SIpQsiqQjkJw/edit#gid=0

πŸ‘‰ Kindly check how to add product images

Sample product file in Google Sheets with the required id, title, description, availability, condition, price, link and image_link columns
  • Please confirm these settings before uploading the product: Name, URL, Default currency, and Data Feed Schedule
Please confirm these settings before uploading the product: Name, URL, Default currency, and Data Feed Schedule
  • It takes a few minutes to review your products and automatically upload them.

⚑Note 1: If you want to update or add items, use the same spreadsheet. It will be automatically synced with your catalogue.

⚑ Note 2: If all items are green, they've been successfully added or updated. If any are red or yellow, there was an error. To find out why, click "Download Report" and update the Data Feed URL accordingly.

The items have been successfully added from the Data feed URL.
The items have been successfully added from the Data feed URL.
Commerce Manager Items list showing the two products added from the data feed

The items have been successfully added.


(Or)

(ii) XLSX or CSV File using uploads in bulk​

  • Select the Download template button, Choose template format XLSX or CSV download it and Upload your products.
  • Choose the Upload from your computer option and Drag and drop your updated XLSX or CSV file to upload your products.
Choose the Upload from your computer option and Drag and drop your updated XLSX or CSV file to upload your products.
  • Open that downloaded XLSX or CSV file to upload your products.
  • Enter your product details such as ID, Title, Description, Availability, Condition, Price, Link (Website), Image_link and Brand, etc.

⚑ Note: The fields highlighted in blue color are mandatory product details. The other fields are optional.

Note: The fields highlighted in blue color are mandatory product details. The other fields are optional.
Note: The fields highlighted in blue color are mandatory product details. The other fields are optional.

How to add product images​

  • Image link needs to be hosted and accessible on the internet, If you already have it hosted on your E-Commerce website or somewhere else, you could directly use the link. If you don't have one, Please use the Google Drive image hosting option below.

Google Drive Image Hosting:

Example: https://drive.google.com/uc?id=1HNSsCmLupyKLUg8NuV8C5WrsNg1g_zJD

  • Upload your product images on Google Drive and set the folder access Anyone with the link πŸ‘‡
Upload your product images on Google Drive and set the folder access Anyone with the link
  • Copy your product image Copy link option, and open it with a new tab. πŸ‘‡
Copy your product image Copy link option, and open it with a new tab.
  • Copy the image ID from the URL (Check the reference picture, the image ID is marked as red) and paste it into the XLSX or CSV file. πŸ‘‡
Note: Copy the image ID from the URL (Check the reference picture, the image ID is marked as red)
Note: Copy the image ID from the URL (Check the reference picture, the image ID is marked as red)
  • Once you've added all the products to an XLSX or CSV file, simply drag and drop the file to upload it. Then click the "Next" button to proceed.
Once you've added all the products to an XLSX or CSV file, simply drag and drop the file to upload it. Then click the "Next" button to proce
  • It takes a few minutes to review products for ready to upload. Finally, select the Upload Now button.

⚑ Note: If all items show green, proceed to upload. If any items show red errors, select the "View Report" button to check the error reason, update it, and re-upload.

Data source overview with the Upload Now button and an upload session showing 2 items updated or added and 0 errors
Commerce Manager Items list showing the two products uploaded from the file

The items have been successfully added.