Price Question

Pending
ImportWP Pro - WordPress XML & CSV Importer ImportWP Pro - WordPress XML & CSV Importer November 09, 2021
Login to reply
James Collings Support Agent
2 years ago

The speed of the importer comes down to the power of the server and how many wordpress plugins you have installed, and how many images each record is importing.

The importer does allow for chunks of the importer to run in parrallel, you can enable this by adding multiple wordpress crons in your systems task manager.

https://developer.wordpress.org/plugins/cron/hooking-wp-cron-into-the-system-task-scheduler/

for example if you have setup 5 wordpress crons in your servers task manager, in theory it should speed up to 5x if you server can handle that.

MIhail Mihaylov
2 years ago

Hello,

am i doing something wrong, or is it actually that slow (see screenshot) ? I need this file to be updated every couple of hours or so, will it be that slow when it updates ?

Thank you 

MIhail Mihaylov
2 years ago

`

### wp-core ###

version: 5.8.2

site_language: bg_BG

user_language: bg_BG

timezone: +00:00

permalink: /%category%/%postname%/

https_status: true

multisite: false

user_registration: 0

blog_public: 1

default_comment_status: open

environment_type: production

user_count: 4

dotorg_communication: true

### wp-paths-sizes ###

wordpress_path: /home/misho/public_html

wordpress_size: 61,64 MB (64637797 bytes)

uploads_path: /home/misho/public_html/wp-content/uploads

uploads_size: 227,26 MB (238295621 bytes)

themes_path: /home/misho/public_html/wp-content/themes

themes_size: 30,67 MB (32155165 bytes)

plugins_path: /home/misho/public_html/wp-content/plugins

plugins_size: 173,96 MB (182409674 bytes)

database_size: 1,27 GB (1360175310 bytes)

total_size: 1,75 GB (1877673567 bytes)

### wp-dropins (2) ###

advanced-cache.php: true

object-cache.php: true

### wp-active-theme ###

name: Porto (porto)

version: 6.2.2

author: P-THEMES

author_website: https://www.portotheme.com/

parent_theme: none

theme_features: core-block-patterns, widgets-block-editor, post-thumbnails, title-tag, editor-style, automatic-feed-links, woocommerce, menus, post-formats, html5, wp-block-styles, responsive-embeds, align-wide, editor-styles, editor-color-palette, widgets

theme_path: /home/misho/public_html/wp-content/themes/porto

auto_update: Изключено

### wp-themes-inactive (1) ###

Twenty Twenty-One: version: 1.4, author: Екипът на WordPress, Автоматичното обновяване е изключено

### wp-plugins-active (26) ###

BDroppy: version: 2.5.10, author: BDroppy Development Team, Автоматичното обновяване е изключено

Classic Editor: version: 1.6.2, author: WordPress Contributors, Автоматичното обновяване е изключено

Contact Form 7: version: 5.5.2, author: Takayuki Miyoshi, Автоматичното обновяване е изключено

Dynamic Featured Image: version: 3.7.0, author: Ankit Pokhrel, Автоматичното обновяване е изключено

Econt Delivery: version: 2.5.23, author: Econt Express LTD., Автоматичното обновяване е изключено

Elementor: version: 3.4.7, author: Elementor.com, Автоматичното обновяване е изключено

Elementor Pro: version: 3.5.1, author: Elementor.com, Автоматичното обновяване е изключено

ELEX WooCommerce Bulk Edit Products, Prices & Attributes (Basic): version: 1.2.0, author: ELEXtensions, Автоматичното обновяване е изключено

Essential Addons for Elementor: version: 4.9.6, author: WPDeveloper, Автоматичното обновяване е изключено

Essential Addons for Elementor - Pro: version: 4.4.9, author: WPDeveloper, Автоматичното обновяване е изключено

Hello Dolly: version: 1.7.2, author: Matt Mullenweg, Автоматичното обновяване е изключено

ImportWP - WooCommerce Importer Addon: version: 2.0.9, author: James Collings <james@jclabs.co.uk>, Автоматичното обновяване е изключено

ImportWP PRO: version: 2.2.4, author: James Collings <james@jclabs.co.uk>, Автоматичното обновяване е изключено

Jetpack: version: 10.3, author: Automattic, Автоматичното обновяване е изключено

LiteSpeed Cache: version: 4.4.3, author: LiteSpeed Technologies, Автоматичното обновяване е изключено

MonsterInsights - eCommerce Addon: version: 7.0.7, author: MonsterInsights Team, Автоматичното обновяване е изключено

MonsterInsights Pro: version: 7.18.0, author: MonsterInsights, Автоматичното обновяване е изключено

Nextend Social Login: version: 3.1.2, author: Nextendweb, Автоматичното обновяване е изключено

Porto Theme - Functionality: version: 2.2.1, author: P-Themes, Автоматичното обновяване е изключено

Product Filter for WooCommerce: version: 8.2.0, author: XforWooCommerce, Автоматичното обновяване е изключено

TBI Pay BNPL: version: 1.2.0, author: Ilko Ivanov, Автоматичното обновяване е изключено

WooCommerce: version: 5.9.0, author: Automattic, Автоматичното обновяване е изключено

WooCommerce Stripe Gateway: version: 5.7.0, author: WooCommerce, Автоматичното обновяване е изключено

YITH WooCommerce Wishlist: version: 3.3.0, author: YITH, Автоматичното обновяване е изключено

Yoast SEO: version: 17.3, author: Team Yoast (latest version: 17.5), Автоматичното обновяване е изключено

Yoast SEO Premium: version: 16.3, author: Team Yoast, Автоматичното обновяване е изключено

### wp-plugins-inactive (3) ###

Akismet Anti-Spam: version: 4.2.1, author: Automattic, Автоматичното обновяване е изключено

Facebook for WooCommerce: version: 2.6.7, author: Facebook, Автоматичното обновяване е изключено

Restricted Site Access: version: 7.2.0, author: Jake Goldman, 10up, Oomph, Автоматичното обновяване е изключено

### wp-media ###

image_editor: WP_Image_Editor_Imagick

imagick_module_version: 1692

imagemagick_version: ImageMagick 6.9.12-28 Q16 x86_64 2021-10-29 https://imagemagick.org

imagick_version: 3.5.1

file_uploads: File uploads is turned off

post_max_size: 1024M

upload_max_filesize: 1024M

max_effective_size: 1 GB

max_file_uploads: 20

imagick_limits:

 imagick::RESOURCETYPE_AREA: 9 GB

 imagick::RESOURCETYPE_DISK: 9.2233720368548E+18

 imagick::RESOURCETYPE_FILE: 3072

 imagick::RESOURCETYPE_MAP: 9 GB

 imagick::RESOURCETYPE_MEMORY: 5 GB

 imagick::RESOURCETYPE_THREAD: 1

imagemagick_file_formats: 3FR, 3G2, 3GP, AAI, AI, APNG, ART, ARW, AVI, AVS, BGR, BGRA, BGRO, BIE, BMP, BMP2, BMP3, BRF, CAL, CALS, CANVAS, CAPTION, CIN, CIP, CLIP, CMYK, CMYKA, CR2, CR3, CRW, CUR, CUT, DATA, DCM, DCR, DCX, DDS, DFONT, DNG, DOT, DPX, DXT1, DXT5, EPDF, EPI, EPS, EPS2, EPS3, EPSF, EPSI, EPT, EPT2, EPT3, ERF, EXR, FAX, FILE, FITS, FRACTAL, FTP, FTS, G3, G4, GIF, GIF87, GRADIENT, GRAY, GRAYA, GROUP4, GV, H, HALD, HDR, HISTOGRAM, HRZ, HTM, HTML, HTTP, HTTPS, ICB, ICO, ICON, IIQ, INFO, INLINE, IPL, ISOBRL, ISOBRL6, J2C, J2K, JBG, JBIG, JNG, JNX, JP2, JPC, JPE, JPEG, JPG, JPM, JPS, JPT, JSON, K25, KDC, LABEL, M2V, M4V, MAC, MAGICK, MAP, MASK, MAT, MATTE, MEF, MIFF, MKV, MNG, MONO, MOV, MP4, MPC, MPG, MRW, MSL, MSVG, MTV, MVG, NEF, NRW, NULL, ORF, OTB, OTF, PAL, PALM, PAM, PANGO, PATTERN, PBM, PCD, PCDS, PCL, PCT, PCX, PDB, PDF, PDFA, PEF, PES, PFA, PFB, PFM, PGM, PGX, PICON, PICT, PIX, PJPEG, PLASMA, PNG, PNG00, PNG24, PNG32, PNG48, PNG64, PNG8, PNM, POCKETMOD, PPM, PREVIEW, PS, PS2, PS3, PSB, PSD, PTIF, PWP, RADIAL-GRADIENT, RAF, RAS, RAW, RGB, RGBA, RGBO, RGF, RLA, RLE, RMF, RW2, SCR, SCT, SFW, SGI, SHTML, SIX, SIXEL, SPARSE-COLOR, SR2, SRF, STEGANO, SUN, SVG, SVGZ, TEXT, TGA, THUMBNAIL, TIFF, TIFF64, TILE, TIM, TTC, TTF, TXT, UBRL, UBRL6, UIL, UYVY, VDA, VICAR, VID, VIDEO, VIFF, VIPS, VST, WBMP, WEBM, WEBP, WMF, WMV, WMZ, WPG, X, X3F, XBM, XC, XCF, XPM, XPS, XV, XWD, YCbCr, YCbCrA, YUV

gd_version: 2.3.3

gd_formats: GIF, JPEG, PNG, WebP, BMP, XPM

ghostscript_version: not available

### wp-server ###

server_architecture: Linux 3.10.0-1160.45.1.el7.x86_64 x86_64

httpd_software: LiteSpeed

php_version: 7.3.32 64bit

php_sapi: litespeed

max_input_variables: 3000

time_limit: 600

memory_limit: 512M

max_input_time: -1

upload_max_filesize: 1024M

php_post_max_size: 1024M

curl_version: 7.29.0 NSS/3.53.1

suhosin: false

imagick_availability: true

pretty_permalinks: true

htaccess_extra_rules: true

### wp-database ###

extension: mysqli

server_version: 10.4.21-MariaDB

client_version: mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

### wp-constants ###

WP_HOME: undefined

WP_SITEURL: undefined

WP_CONTENT_DIR: /home/misho/public_html/wp-content

WP_PLUGIN_DIR: /home/misho/public_html/wp-content/plugins

WP_MEMORY_LIMIT: 40M

WP_MAX_MEMORY_LIMIT: 512M

WP_DEBUG: false

WP_DEBUG_DISPLAY: true

WP_DEBUG_LOG: false

SCRIPT_DEBUG: false

WP_CACHE: false

CONCATENATE_SCRIPTS: undefined

COMPRESS_SCRIPTS: undefined

COMPRESS_CSS: undefined

WP_LOCAL_DEV: undefined

DB_CHARSET: utf8

DB_COLLATE: undefined

### wp-filesystem ###

wordpress: writable

wp-content: writable

uploads: writable

plugins: writable

themes: writable

### jetpack ###

site_id: 198015367

ssl_cert: No

time_diff: undefined

version_option: 10.3:1635937952

old_version: 10.2.1:1634715033

public: Public

master_user: #1 magaziya

current_user: #1 magaziya

tokens_set: Blog User

blog_token: xRObTgudr!@IHasDLE7k#csPtaXC6H7J

user_token: qal1N7EY384FA()C870yuqqGB)bGu0QS

version: 10.3

jp_plugin_dir: /home/misho/public_html/wp-content/plugins/jetpack/

plan: free

protect_header: {"trusted_header":"REMOTE_ADDR","segments":1,"reverse":false}

full_sync: {"started":"Mon, 27 Sep 2021 15:26:44 +0000","finished":"Mon, 27 Sep 2021 15:26:52 +0000","progress":{"options":{"finished":true},"functions":{"finished":true},"constants":{"finished":true},"users":{"total":"1","sent":1,"finished":true,"last_sent":"1"},"network_options":{"finished":true}},"config":{"options":true,"functions":true,"constants":true,"users":[1],"network_options":true}}

sync_size: 88

sync_lag: 6 seconds

full_sync_size: undefined

full_sync_lag: 0 seconds

idc_urls: {"home":"https:\/\/www.magaziya.com","siteurl":"https:\/\/www.magaziya.com","WP_HOME":"","WP_SITEURL":""}

idc_error_option: false

idc_optin: true

cxn_tests: {"12":{"name":"test__sync_health","label":"Jetpack has detected an error syncing your site.","short_description":"Jetpack has detected that data is not properly in sync which may be impacting some of your site\u2019s functionality. We recommend performing a fix to align Jetpack with your site data. If you still notice this error after running the fix process, please contact support for additional assistance.","long_description":"<p>The information synced by Jetpack ensures that Jetpack Search, Related Posts and other features are aligned with your site\u2019s current content.<\/p><p><span class=\"dashicons fail\"><span class=\"screen-reader-text\">Error<\/span><\/span> Jetpack has detected that data is not properly in sync which may be impacting some of your site\u2019s functionality. <strong>Click <a id=\"full_sync_request_link\" href=\"#\">here<\/a> to start a fix<\/strong> to align Jetpack with your site data. If you still notice this error after running the fix process, please contact support for additional assistance.<\/p>","severity":"critical","action":"https:\/\/jetpack.com\/redirect\/?source=jetpack-contact-support&site=www.magaziya.com","action_label":"Contact Jetpack Support","show_in_site_health":true,"pass":false,"group":["default"],"type":"direct"}}

`

James Collings Support Agent
2 years ago

In regards to the ACF installation issue, can you confirm which versions of of importwp and importwp-acf you have installed by going to Tools > Site Health > Info and attaching the results from "copy th site info to clipboard".

James

James Collings Support Agent
2 years ago

Hi,

If you can add the following code to your themes functions file: https://pastebin.com/LakwFHCq

The code adds 90% onto the price i is given.

You would use it like:

[iwpt_increase_price_by_90("{8}")]

replacing {8} with the csv column number you need.

This will only effect the importer it is added to.

James

MIhail Mihaylov
2 years ago
Also do i need Advanced Custom Fields Importer for this job, because i have problems installing it, i am attaching screenshots ?
MIhail Mihaylov
2 years ago
Thank you so much for the reply, i am ataching a exaple csv. I want the "sale price" to be +90%
James Collings Support Agent
2 years ago

Hi Михаил Михайлов ,

The best way to alter data before being imported is to use custom functions (an example of how to alter the date can be found here: https://www.importwp.com/documentation/modifying-dates-using-custom-methods/ ) , using that as an example you can create a custom function to change your product prices before being imported.

If you need any help with creating the function or using it, can you please share an example record/row of csv/xml and let me know what the correct output should be.

Thanks
James

MIhail Mihaylov
2 years ago

Hello, i am importing a csv with products from my supplier. The sell price in the file is the price that i pay for the products, i want to modify it to be +90% from that. So if the sell prce for a products is 10$ in the csv file, i want to be modified to be 19$ in my shop. How can i do that ? Thank you :)