I am experiencing an issue with importing product data from a CSV file into my WordPress site. The import function does not properly store the download_url field in the site's database. I need an experienced WordPress developer to review my import scripts and correct the issue to ensure that the download_url is correctly saved.
Current Setup:
The site runs on WordPress with a custom product import functionality.
This functionality is part of a custom plugin developed by us.
The import function is structured in two key PHP files:
importpage.products.php: Handles file uploads and processes CSV data.
import.products.php: Inserts the imported product data into the database.
The CSV file includes a download_url column with valid URLs.
The import function successfully imports all other product data except for download_url.
Issue Description:
The download_url field is present in the CSV file but is not being stored in the WordPress database.
The download_url is not appearing in the product meta fields.
When download_url is not empty, it must also populate the supplier field with dp.
Attempts to manually modify the import scripts to include download_url have not worked.
No errors are displayed, and database insertions appear to be occurring, but the download_url data is missing.
Expected Outcome:
Review and debug the existing import scripts.
Modify the scripts so that download_url is properly read from the CSV file.
Ensure that download_url is stored as a product meta field or in the appropriate database table.
Ensure that when download_url is not empty, the supplier field is automatically set to dp.
Verify that download_url is correctly associated with each imported product.
Provide a detailed summary of the fixes implemented and any necessary documentation.
Skills Required:
Strong knowledge of PHP and WordPress development.
Experience with WordPress database operations (wpdb and post_meta).
Debugging and troubleshooting PHP scripts.
Familiarity with CSV data handling and parsing.
Deliverables:
Updated PHP scripts (importpage.products.php and import.products.php) with the fix implemented.
Testing and confirmation that download_url is correctly saved.
Ensure supplier is set to dp when download_url is not empty.
A brief explanation of what was changed and why.
If you have experience with WordPress product imports and debugging database-related issues, please get in touch with a proposal and estimated timeframe for completion. Thank you!
