There are a few problems with the WooCommerce CSV Import Suite that I have come up against. Some I have already talked about, but here are a few more. Some have workarounds, and some are just a little puzzling. I am hoping that most of these issues will be solved by the time you need […]
Archive | Data Migration
WooCommerce CSV Import – Some Notes
Phew! Just finished migrating 20,000 products to a new WooCommerce shop. Raised a bunch of tickets with WooThemes too, through their incredibly sucky “UserVoice” integration, pretending to be a ticket system (but that’s a winge for another day). The import was interesting, too say the least, and I thought it a good idea to post […]
SugarCRM: Permissions issue importing updated records
I got this error while importing updated email addresses for existing contact records: The record could not be updated due to a permissions issue This happened for just ten records out of three thousand, and I was logged in as an administrator, so there should not have been any real privilege issues. The answer was […]
SugarCRM: Importing multiple contact emails
When importing contacts from CSV data, you may want to import more than one email into a contact. The default SugarCRM CE supports the import of two email addresses: a primary email address and one tertiary email address. More can be added manually later. The primary email address is imported from column “Email Address” and […]
MySQL – finding counts of data by columns
Okay, the title may not be clear, but this is basically what I was trying to do, and I present here the script that achieved it. During a data migration of a legacy Access database (actually, nine Access databases) to Sugar CRM, I wanted to be able to find any data that was missing. Looking […]