monicalangley001

Hi Aashik,

Thank You for replaying!

I did try that and URLs did show up after this import, but all the URLs were of old store which I understand that’s how import works but as all of my products are virtual downloadable, when customer purchases some products, after clicking on download link it takes the customer to my old store and then on 404 error…

Hi,

I’m not exactly sure of the manual process you’ve taken here. Would you mind sharing more details, please?

I downloaded files and database and uploaded in new directory… and changed links of old domain with new domain in database.

As for fixing the products itself, what happens if you make a complete export of products from your old site, fix the URLs to match the downloadable links for your new URL and remove the image field to prevent duplicate images, and then import the CSV on your new site as per the instructions in Product CSV Importer and Exporter?

Before I do that, I guess there are URLs in database for downloadable files in wp_postmeta table and in meta_calue the _downloadable_files entries are still there and I have verified that the URL’s in the table are still valid.

So I just wanted to make sure that this is the right way to go?

1) I did manually but did changed all the links from database.

2) Screenshots

????? — Old site screenshot (having URL) https://snipboard.io/JjbhKz.jpg
????? — New site screenshot (No URL) https://snipboard.io/DJ84ir.jpg

This is the case with all the products in new site. I checked all the files which should be in url are there in my file manager directory.

3) System Status

### WordPress Environment ###

WordPress address (URL): https://www.docformats.net
Site address (URL): https://www.docformats.net
WC Version: 3.8.1
REST API Version: ? 1.0.2
Log Directory Writable: ?
WP Version: 5.3.2
WP Multisite: –
WP Memory Limit: 256 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
External object cache: ?

### Server Environment ###

Server Info: Apache
PHP Version: 7.1.33 - We recommend using PHP version 7.2 or above for greater performance and security. How to update your PHP version
PHP Post Max Size: 32 MB
PHP Time Limit: 300
PHP Max Input Vars: 8000
cURL Version: 7.67.0
OpenSSL/1.0.2t

SUHOSIN Installed: –
MySQL Version: 5.5.5-10.1.43-MariaDB
Max Upload Size: 32 MB
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
GZip: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

### Database ###

WC Database Version: 3.8.1
WC Database Prefix: wpyr_
MaxMind GeoIP Database: ?
Total Database Size: 43.01MB
Database Data Size: 27.96MB
Database Index Size: 15.05MB
wpyr_woocommerce_sessions: Data: 1.52MB + Index: 0.05MB + Engine InnoDB
wpyr_woocommerce_api_keys: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_woocommerce_attribute_taxonomies: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_woocommerce_downloadable_product_permissions: Data: 0.17MB + Index: 0.34MB + Engine InnoDB
wpyr_woocommerce_order_items: Data: 0.13MB + Index: 0.05MB + Engine InnoDB
wpyr_woocommerce_order_itemmeta: Data: 1.52MB + Index: 0.66MB + Engine InnoDB
wpyr_woocommerce_tax_rates: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpyr_woocommerce_tax_rate_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_woocommerce_shipping_zones: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_woocommerce_shipping_zone_locations: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_woocommerce_shipping_zone_methods: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_woocommerce_payment_tokens: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_woocommerce_payment_tokenmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_woocommerce_log: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_arf_ar: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_arf_autoresponder: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_arf_entries: Data: 0.02MB + Index: 0.06MB + Engine InnoDB
wpyr_arf_entry_values: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_arf_fields: Data: 0.16MB + Index: 0.03MB + Engine InnoDB
wpyr_arf_fields_backup: Data: 0.31MB + Index: 0.03MB + Engine InnoDB
wpyr_arf_forms: Data: 0.31MB + Index: 0.02MB + Engine InnoDB
wpyr_arf_forms_backup: Data: 0.20MB + Index: 0.02MB + Engine InnoDB
wpyr_arf_popup_forms: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_arf_views: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_categorymeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_commentmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_comments: Data: 0.19MB + Index: 0.25MB + Engine InnoDB
wpyr_ewwwio_images: Data: 1.52MB + Index: 1.64MB + Engine InnoDB
wpyr_ewwwio_queue: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_jmsflashsales_cats: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_jms_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_jms_slider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_links: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_member_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_options: Data: 2.47MB + Index: 0.08MB + Engine InnoDB
wpyr_portfolio_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_postmeta: Data: 13.52MB + Index: 8.03MB + Engine InnoDB
wpyr_posts: Data: 2.52MB + Index: 2.20MB + Engine InnoDB
wpyr_product_catmeta: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_revslider_css: Data: 0.13MB + Index: 0.00MB + Engine InnoDB
wpyr_revslider_layer_animations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_revslider_navigations: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_revslider_sliders: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_revslider_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_revslider_static_slides: Data: 0.02MB + Index: 0.00MB + Engine InnoDB
wpyr_termmeta: Data: 0.02MB + Index: 0.03MB + Engine InnoDB
wpyr_terms: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpyr_term_relationships: Data: 0.22MB + Index: 0.13MB + Engine InnoDB
wpyr_term_taxonomy: Data: 0.05MB + Index: 0.03MB + Engine InnoDB
wpyr_usermeta: Data: 0.27MB + Index: 0.25MB + Engine InnoDB
wpyr_users: Data: 0.05MB + Index: 0.05MB + Engine InnoDB
wpyr_wc_download_log: Data: 0.13MB + Index: 0.14MB + Engine InnoDB
wpyr_wc_product_meta_lookup: Data: 0.14MB + Index: 0.33MB + Engine InnoDB
wpyr_wc_tax_rate_classes: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_wc_webhooks: Data: 0.02MB + Index: 0.02MB + Engine InnoDB
wpyr_woocommerce_pinterest: Data: 0.05MB + Index: 0.00MB + Engine InnoDB
wpyr_yoast_seo_links: Data: 1.52MB + Index: 0.22MB + Engine InnoDB
wpyr_yoast_seo_meta: Data: 0.13MB + Index: 0.00MB + Engine InnoDB

### Security ###

Secure connection (HTTPS): ?
Hide errors from visitors: ?

### Active Plugins (18) ###

ManageWP - Worker: by GoDaddy – 4.9.2
Adminimize: by Frank Bültge – 1.11.5
ARForms - Premium WordPress Form Builder Plugin: by Repute InfoSystems – 3.7.1
Classic Editor: by WordPress Contributors – 1.5
Contact Form 7: by Takayuki Miyoshi – 5.1.6
EWWW Image Optimizer: by Exactly WWW – 5.1.3
FV Top Level Categories: by Foliovision – 1.9.1
Jetpack by WordPress.com: by Automattic – 8.0
WPBakery Page Builder: by Michael M - WPBakery.com – 6.0.5
Porto Theme - Functionality: by P-Themes – 1.5.1
Redis Object Cache: by Till Krüss – 1.5.5
2Checkout Payment Gateway: by Craig Christenson – 0.0.2 – Not tested with the active version of WooCommerce
2Checkout PayPal Direct Gateway: by Craig Christenson – 0.0.2 – Not tested with the active version of WooCommerce
WooCommerce Blocks: by Automattic – 2.5.4
Pinterest for WooCommerce: by premmerce – 1.1.3 – Not tested with the active version of WooCommerce
WooCommerce: by Automattic – 3.8.1
Yoast SEO: by Team Yoast – 12.7.1
WP Rocket: by WP Media – 3.4.2.2

### Inactive Plugins (1) ###

WPS Hide Login: by WPServeur
NicolasKulka
tabrisrp – 1.5.4.2

### Dropin Plugins (2) ###

advanced-cache.php: advanced-cache.php
object-cache.php: Redis Object Cache Drop-In

### Must Use Plugins (1) ###

ManageWP - Worker Loader: by ManageWP –

### Settings ###

API Enabled: ?
Force SSL: ?
Currency: USD ($)
Currency Position: left
Thousand Separator: ,
Decimal Separator: .
Number of Decimals: 2
Taxonomies: Product Types: external (external)
grouped (grouped)
simple (simple)
variable (variable)

Taxonomies: Product Visibility: exclude-from-catalog (exclude-from-catalog)
exclude-from-search (exclude-from-search)
featured (featured)
outofstock (outofstock)
rated-1 (rated-1)
rated-2 (rated-2)
rated-3 (rated-3)
rated-4 (rated-4)
rated-5 (rated-5)

Connected to WooCommerce.com: –

### WC Pages ###

Shop base: #6 - /
Cart: #1590 - /cart-2/
Checkout: #1591 - /checkout-2/
My account: #9 - /my-account-2/
Terms and conditions: #21 - /terms-and-conditions/

### Theme ###

Name: Porto Child
Version: 1.1
Author URL: https://newsmartwave.net/
Child Theme: ?
Parent Theme Name: Porto
Parent Theme Version: 5.1.1
Parent Theme Author URL: https://www.portotheme.com/
WooCommerce Support: ?

### Templates ###

Overrides: porto/woocommerce/archive-product.php
porto/woocommerce/cart/cart-shipping.php
porto/woocommerce/cart/cart-totals.php
porto/woocommerce/cart/cart.php
porto/woocommerce/cart/cross-sells.php
porto/woocommerce/cart/mini-cart.php
porto/woocommerce/cart/proceed-to-checkout-button.php
porto/woocommerce/cart/shipping-calculator.php
porto/woocommerce/checkout/form-billing.php
porto/woocommerce/checkout/form-checkout.php
porto/woocommerce/checkout/form-coupon.php
porto/woocommerce/checkout/form-login.php
porto/woocommerce/checkout/form-pay.php
porto/woocommerce/checkout/payment.php
porto/woocommerce/checkout/review-order.php
porto/woocommerce/content-product.php
porto/woocommerce/content-product_cat.php
porto/woocommerce/content-single-product.php
porto/woocommerce/content-widget-product.php
porto/woocommerce/global/form-login.php
porto/woocommerce/global/quantity-input.php
porto/woocommerce/global/wrapper-start.php
porto/woocommerce/loop/add-to-cart.php
porto/woocommerce/loop/loop-end.php
porto/woocommerce/loop/loop-start.php
porto/woocommerce/loop/no-products-found.php
porto/woocommerce/loop/orderby.php
porto/woocommerce/loop/pagination.php
porto/woocommerce/loop/rating.php
porto/woocommerce/loop/sale-flash.php
porto/woocommerce/myaccount/downloads.php
porto/woocommerce/myaccount/form-add-payment-method.php
porto/woocommerce/myaccount/form-edit-account.php
porto/woocommerce/myaccount/form-edit-address.php
porto/woocommerce/myaccount/form-login.php
porto/woocommerce/myaccount/form-lost-password.php
porto/woocommerce/myaccount/form-reset-password.php
porto/woocommerce/myaccount/lost-password-confirmation.php
porto/woocommerce/myaccount/my-account.php
porto/woocommerce/myaccount/my-address.php
porto/woocommerce/myaccount/my-downloads.php
porto/woocommerce/myaccount/my-orders.php
porto/woocommerce/myaccount/orders.php
porto/woocommerce/myaccount/payment-methods.php
porto/woocommerce/myaccount/view-order.php
porto/woocommerce/order/form-tracking.php
porto/woocommerce/order/tracking.php
porto/woocommerce/single-product/add-to-cart/simple.php
porto/woocommerce/single-product/add-to-cart/variable.php
porto/woocommerce/single-product/meta.php
porto/woocommerce/single-product/product-attributes.php
porto/woocommerce/single-product/product-image.php
porto/woocommerce/single-product/product-thumbnails.php
porto/woocommerce/single-product/rating.php
porto/woocommerce/single-product/related.php
porto/woocommerce/single-product/review-meta.php
porto/woocommerce/single-product/review-rating.php
porto/woocommerce/single-product/review.php
porto/woocommerce/single-product/sale-flash.php
porto-child/woocommerce/single-product/short-description.php
porto/woocommerce/single-product/tabs/tabs.php
porto/woocommerce/single-product/title.php
porto/woocommerce/single-product/up-sells.php
porto/woocommerce/single-product-reviews.php

### Action Scheduler ###

Complete: 14
Oldest: 2019-11-21 13:23:40 +0000
Newest: 2019-12-19 10:23:45 +0000

Pending: 1
Oldest: 2019-12-19 13:28:35 +0000
Newest: 2019-12-19 13:28:35 +0000

Canceled: 0
Oldest: –
Newest: –

In-progress: 0
Oldest: –
Newest: –

Failed: 0
Oldest: –
Newest: –

Thank You!