Sample PHP Code for Generating a Product Feed (CSV)
Below is an example of how to generate a CSV product feed using PHP. This method can be used for creating product feeds for platforms like Hub of Sales (HOS) or other e-commerce marketplaces.
Sample PHP Code for Generating a Product Feed (CSV)
Below is an example of how to generate a CSV product feed using PHP with the following structure:
CSV Columns:
- Site
- SKU
- Category
- Name
- Description
- Brand
- Price
- Price offer
- Stock
- Photo URL
- Product Link
Sample Code:
<?php
// Set header for CSV download
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="product-feed.csv"');
// Open output stream
$output = fopen('php://output', 'w');
// Write column headers
fputcsv($output, ['Site', 'SKU', 'Category', 'Name', 'Description', 'Brand', 'Price', 'Price offer', 'Stock', 'Photo URL', 'Product Link']);
// Sample product data
$products = [
header('Content-Type: text/csv');
header('Content-Disposition: attachment; filename="product-feed.csv"');
// Open output stream
$output = fopen('php://output', 'w');
// Write column headers
fputcsv($output, ['Site', 'SKU', 'Category', 'Name', 'Description', 'Brand', 'Price', 'Price offer', 'Stock', 'Photo URL', 'Product Link']);
// Sample product data
$products = [
['example.com', 'SKU001', 'Category1|Category2|Category3', 'Sample Product 1', 'Description for product 1', 'Brand','100.00', '90.00', '10', 'https://example.com/photo1.jpg|https://example.com/photo2.jpg|https://example.com/photo3.jpg', 'https://example.com/product1'],
['example.com', 'SKU002', 'Category1|Category2|Category3', 'Sample Product 2', 'Description for product 2', 'Brand','200.00', '180.00', '5', 'https://example.com/photo1.jpg|https://example.com/photo2.jpg|https://example.com/photo3.jpg', 'https://example.com/product2'],
['example.com', 'SKU003', 'Category1|Category2|Category3', 'Sample Product 3', 'Description for product 3', 'Brand','300.00', '270.00', '8', 'https://example.com/photo1.jpg|https://example.com/photo2.jpg|https://example.com/photo3.jpg', 'https://example.com/product3']
['example.com', 'SKU002', 'Category1|Category2|Category3', 'Sample Product 2', 'Description for product 2', 'Brand','200.00', '180.00', '5', 'https://example.com/photo1.jpg|https://example.com/photo2.jpg|https://example.com/photo3.jpg', 'https://example.com/product2'],
['example.com', 'SKU003', 'Category1|Category2|Category3', 'Sample Product 3', 'Description for product 3', 'Brand','300.00', '270.00', '8', 'https://example.com/photo1.jpg|https://example.com/photo2.jpg|https://example.com/photo3.jpg', 'https://example.com/product3']
];
// Write each product row to the CSV file
foreach ($products as $product) {
fputcsv($output, $product);
}
// Close output stream
fclose($output);
// Write each product row to the CSV file
foreach ($products as $product) {
fputcsv($output, $product);
}
// Close output stream
fclose($output);
?>
Instructions for Use:
- Copy the code above into a .php file, then place the file on your website.
- Register the link for generating csv in your account.
- Set the interval at which the information will be refreshed.
You can modify this code to add more products, integrate data from a database, or adjust the format as needed.
Please do not change the order of the columns in the CSV.
For platforms like Magento, PrestaShop, OpenCart or WooCommerce, you may prefer using modules for more advanced integrations.
If you have any questions or need further customization, feel free to reach out!