Hello,
there isn't a built-in function to directly export all collections, including SEO Title, Meta Description, and URL, like you can with products. However, you can achieve this using Velo (Wix's coding platform) and the Wix Data API to extract the collection data and export it as a CSV file.
Solution: Export All Collections with SEO Data
To export all collections, including SEO Title, Meta Description, and URL, follow these steps:
Step 1: Create a Backend Function to Fetch Collections
Wix stores collections as database collections in the Content Manager. You can use the wixData API to retrieve them.
Backend Code (backend/data.jsw)
javascript
Copy
Edit
import wixData from 'wix-data';
import { ok, notFound, serverError } from 'wix-http-functions';
export async function getCollections(request) {
try {
// Fetch all collections
const results = await wixData.query("Stores/Collections").find();
if (results.items.length === 0) {
return notFound({ message: "No collections found" });
}
// Extract required fields
const collectionsData = results.items.map(collection => ({
id: collection._id,
name: collection.name,
seoTitle: collection.seoData?.title || "",
metaDescription: collection.seoData?.description || "",
url: collection.slug ? `https://yourwixsite.com/${collection.slug}` : ""
}));
return ok({ collections: collectionsData });
} catch (error) {
console.error("Error fetching collections:", error);
return serverError({ message: "An error occurred" });
}
}
Step 2: Create a Button to Trigger the Export
Add a button on your Wix page to fetch the collections and export them as a CSV.
Frontend Code (Page Code)
javascript
Copy
Edit
import { getCollections } from 'backend/data.jsw';
$w.onReady(function () {
$w("#exportButton").onClick(async () => {
try {
const response = await getCollections();
if (response.collections.length > 0) {
// Convert data to CSV format
let csvContent = "data:text/csv;charset=utf-8,";
csvContent += "ID,Name,SEO Title,Meta Description,URL\n";
response.collections.forEach(row => {
csvContent += `"${row.id}","${row.name}","${row.seoTitle}","${row.metaDescription}","${row.url}"\n`;
});
// Create download link
const encodedUri = encodeURI(csvContent);
const link = document.createElement("a");
link.setAttribute("href", encodedUri);
link.setAttribute("download", "collections.csv");
document.body.appendChild(link);
link.click(); e-zpassri
document.body.removeChild(link);
} else {
console.log("No collections found.");
}
} catch (error) {
console.error("Error exporting collections:", error);
}
});
});
Best Regard,
lora
